在redhat5.5上用rpm安装mysql 5.6装好mysql之后 见
用mysqladmin修改密码(mysqladmin –u root password “mysql”)提示
mysqladmin:can't turn off logging; error: 'access denied; you need the super privilege forthis operation'
解决办法：
修改mysql登录设置
vi /etc/my.cnf (我们发现etc下没有my.cnf文件)
通过查询知道，安装完mysql 后，/etc/my.cnf 文件默认是不存在的，可以在/usr/share/doc/mysql-servercommunity下找到my-huge.cnf 、my-innodb-heavy-4g.cnf 、my-large.cnf 、mymedium.cnf 、my-small.cnf 等文件，根据内存大小将其中合适你机器配置的文件拷贝到/etc/my.cnf（一般应用选mymedium.cnf即可）
编辑my.cnf文件
在[mysqld]段中加入 skip-grant-tables
保存之后重启mysql服务
/etc/rc.d/init.d/mysql restart
重启mysql服务之后修改mysql密码
[root@shiyue]# mysql
welcome to the mysql monitor. commands endwith ; or \g.
your mysql connection id is 3 to server version: 3.23.56
type 'help;' or '\h' for help. type '\c' to clear the buffer.
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 ( 'mysql' ) where user = 'root' ;
query ok, 0 rows affected (0.00 sec)
rows matched: 2 changed: 0 warnings: 0
mysql> flush privileges ;
query ok, 0 rows affected (0.01 sec)
mysql> quit
bye
退出mysql之后把刚修改的配置文件改回来(vi /etc/my.cnf)
重启mysql服务
mysql-u root -p登录mysql
登陆成功！
再通过navicat连接mysql数据库，，提示can't get hostname for your address
解决方法还是修改my.cnf文件，在[mysqld] 下面添加一行：skip-name-resolve，保存重启mysql(/etc/init.d/mysql restart)
赋权：
mysql –u root –p mysql
show databases
use mysql
grant all on *.* to 'root'@'192.168.1.254'identified by 'mysql';
quit
好重新用navicat进行连接，ok，测试通过！