Fedora 14下 MySQL 更改密码
不知为什么，Fedora 14下用yum安装MySQL后配置挺麻烦，现将更改密码的方法记录一下。
报错问题：
是权限的问题么？不解
解决方法：
1. 修改文件/etc/my.cnf，在[mysqld]段中加入skip-grant-tables，就是在启动打开mysql时跳过权限验证，保存退出。
3.登录mysql修改密码
- [[email protected] mysql]# mysql
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 2
- Server version: 5.1.56 Source distribution
- Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
- This software comes with ABSOLUTELY NO WARRANTY. This is free software,
- and you are welcome to modify and redistribute it under the GPL v2 license
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> USE mysql;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> UPDATE user SET Password = password('passwd') WHERE User = 'root';
- Query OK, 4 rows affected (0.00 sec)
- Rows matched: 4 Changed: 4 Warnings: 0
- mysql> flush privileges;
- Query OK, 0 rows affected (0.00 sec)
- mysql> quit
Good luck
相关推荐
86417413 2020-11-25
tianyayi 2020-08-16
83911930 2020-07-28
89612310 2020-07-27
CNxuwang 2020-07-20
86477414 2020-06-28
TuxedoLinux 2020-06-17
87354452 2020-06-10
行万里 2020-06-09
jLawrencee 2020-05-19
songxiugongwang 2020-03-07
hahhah0 2020-05-08
zhiliang 2020-04-23