1.mysql 安装
2020-08-11 本文已影响0人
_少年不知愁
yum安装
yum -y install mysql-server
开机自启
chkconfig mysqld on
启动mysql
service mysqld start
设置密码
mysql -u root
select user,host,password from mysql.user;
set password for root@localhost=password('root');
exit;
mysql重新登入
mysql -u root -p
开启远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
(远程连接不上可 先
use mysql;
UPDATE user SET Password=PASSWORD('123456') where USER='root';
再重新登入;
)