Ubuntu mysql

sudo service mysql start
sudo service mysql stop

登录MySQL
@>mysql -u root -p
@>密码

//首先为用户创建一个数据库(aaaa)
mysql>create database aaaaDB;
//创建用户
mysql> insert into mysql.user(Host,User,Password) values(‘localhost’,’aa’,password(‘aaaaaaa’));
//授权
mysql>grant all privileges on aaaaDB.* to aa@localhost identified by ‘aaaaaaa’;
mysql>flush privileges;//刷新系统权限表