Ubuntu 10.04 Lucid Lynx mysql

Mysql server 5.1 安装记录

 

参考：

http://library.linode.com/lamp-guides/ubuntu-10.04-lucid/#configure_mysql_and_set_up_databases

http://www.jonathanmoeller.com/screed/?p=1781

 

摘要

 

   sudo apt-get install mysql-server

 

  sudo mysql_install_db

 

mysql_secure_installation

 

mysql -u root -p

 

First, create the database:

CREATE DATABASE newdatabaser;

 

Create a user who can access the database:

CREATE USER newdatabaseruser;

 

Next, set a password for the new user:

SET PASSWORD FOR newdatabaseuser= PASSWORD(“password”);

GRANT ALL PRIVILEGES ON newdatabase.* TO newdatabaseuser IDENTIFIED BY ‘password’;