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’;