mysql初始化后修改密码及赋权
mysql初始化后修改密码及赋权
在丢失root密码的时候，可以这样
方法一：
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
mysql>
更改密码：
update user set password=PASSWORD('123456') where USER='root';
update user set password=PASSWORD('123456') where USER='root';
远程连接赋权
grant all PRIVILEGES on mysql.* to root@'192.168.166.102' identified by '123456';
grant all PRIVILEGES on *.* to root@'%' identified by 'mysql';
my.cnf 文件信息
[client]
default-character-set=utf8
[mysqld]
lower_case_table_names=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default-character-set=utf8
init_connect='SET NAMES utf8'
[mysql]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26845409/viewspace-1704087/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
