一、安装及启动: yum -y install mysql mysql-server #如果安装lamp,则还需要安装: httpd php php-mysql service mysqld start 二、以前版本改改mysql的root密码: 初始设置: mysqladmin -u root password 密码 修改设置: mysql -u root -p mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root'; mysql> FLUSH PRIVILEGES; 5.6以后版本: grep "password" /var/log/mysqld.log 获取自动生成的随机密码 mysql -u root -p(上一步得到密码) SET PASSWORD = PASSWORD('your new password'); ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; flush privileges; 三、创建数据库、用户并授权: mysql -uroot -p create database 数据库名; create user '用户名'@'localhost' identified by '密码'; #localhost仅授权本地访问,如要全局访问则改成 % use 数据库名; grant ALL PRIVILEGES on 数据库名 to '用户名'@'localhost' identified by '密码'; 四、删除、更新权限: use mysql delete from user where user in('用户名'); flush PRIVILEGES; 必须有,否则下一步会出错 create user '用户名'@'%' identified by '密码'; grant ALL PRIVILEGES on 数据库.* to '用户名'@'localhost' identified by '密码'; flush PRIVILEGES;有任何疑问请点击留言: 留言板
本文发布于http://wiki.too2.net,转载请联系本人。