当前位置：网站首页>Problems in installing MySQL in CentOS

Problems in installing MySQL in CentOS

2022-07-19 01:05:00 【Put the stars by the bed】

First, we need the default password to log in ：
Through the command ：grep password /var/log/mysqld.log Find out our temporary password

After logging in, you need to set a new password ：
Through the command ：SET PASSWORD=PASSWORD(‘newPassword’); It should be noted that our new password should comply with the rules , The new password is written in single quotation marks

We also need to set mysql Under the Treasury user In the table root The user allows any ip Connect
command ：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '131499Wzx.' WITH GRANT OPTION;

Finally, we passed FLUSH PRIVILEGES; Re authorize

Set the startup status ：
11、 Set up MySQL Service startup

start-up MySQL service ：systemctl start mysqld.service
stop it MySQL service ：systemctl stop mysqld.service
restart MySQL service ：service mysqld restart
see MySQL Service status ：service mysqld status
This is a MySQL Service startup ： systemctl enable mysqld

原网站

版权声明
本文为[Put the stars by the bed]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207170000537311.html

边栏推荐

猜你喜欢

随机推荐