mysqladmin设置root密码,无效
###启动mysql###
#service mysqld start
#mysqladmin -u root password ‘123456’
###坑爹的报错开始了:##
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
3.安全模式下进入设置密码
###停止mysql服务####
#service mysqld stop
#mysqld_safe –skip-grant-tables &
###输入下面的命令按Enter###
mysql -uroot -p
>use mysql;
3.1.之前版本的解决方案设置root密码
>update user set password=password(“mysql”) where user=’root’;
###又开始坑爹了,下面贴出报错信息###
ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’
3.2.最新mysql版本设置root密码的方法
###查看uesr表的字段,发现真的没有password这个字段###
>desc user \G;
###幸好看到了authentication_string(授权字符串)和password_expired(密码过期枚举),所以继续改,下面的语句不报错了###
>update user set authentication_string=password(‘123456’), password_expired=’N’ where user=”root”;
刷新权限并退出
>flush privileges;
>quit
重启mysql,用密码123456即可登录mysql
#service mysqld start
#mysql -u root -p
设置mysql开机启动
#chkconfig mysqld on
#chkconfig mysqld status
mysql远程登录授权
#mysql -u root -p
>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘qiqi7179’ WITH GRANT OPTION;
>FLUSH PRIVILEGES;
>quit