快速学习-Linux安装MySQL

mysql

yum install mysql mysql-server mysql-devel

完成后，用 /etc/init.d/mysqld start 启动mysql

启动mysql控制台： mysql mysql>; USE mysql; mysql>; UPDATE user SET Password=PASSWORD(‘newpassword’) WHERE user=‘root’; mysql>; FLUSH PRIVILEGES; 允许远程登录 mysql -u root -p Enter Password: mysql>GRANT ALL PRIVILEGES ON . TO ‘用户名’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION; 完成后就能远程管理mysql了。

mysql服务名字 service mysqld start

GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;