安装mysql

系统自动下载和安装Mysql的
yum -y install mysql-server

在服务清单中添加mysql服务
chkconfig �add mysqld

服务启动
service mysqld start

更改密码
mysqladmin -u root password 'newpassword'

登录mysql
mysql -u root -p

删除test数据库
mysql> DROP DATABASE test;

删除匿名帐户
mysql> DELETE FROM mysql.user WHERE user = ";

重载权限
mysql> FLUSH PRIVILEGES;

添加mysql用户：
GRANT ALL PRIVILEGES ON my_db.* TO 'user'@'localhost' IDENTIFIED BY 'password';

📚 返回目录