环境是SUSE 11 SP2,RPM包安装MYSQL 5.6.25
尝试通过MYSQL用户安装,但是出现很多报错,所以最后还是改用ROOT安装。
安装指定数据库目录
mysql_install_db --ldata=/usr/local/mysql/data --defaults-file=/etc/my.cnf --user=root
接下面是无法登录的问题处理:
一:ROOT用户无法登录,报错
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
这个通过搜索网上的方法解决
1.关闭mysql
/etc/init.d/mysql stop
2.屏蔽权限
mysqld_safe --skip-grant-table --user=root&
3.新开起一个终端输入
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql>
二:新建了数据库mos,并授予权限给创建的用户mos,但是mos无法登录数据库
mos:~ # mysql -u mos -p mos
Enter password:
ERROR 1045 (28000): Access denied for user 'mos'@'localhost' (using password: YES)
通过以下两步,绝对可以帮你解决。
1:授权权限
mysql> grant all privileges on *.* to mos@'localhost' identified by "mos" with grant option;
mysql> grant all privileges on *.* to mos@'%' identified by "mos" with grant option;
mysql> grant all privileges on *.* to mos@'mos' identified by "mos" with grant option;
mysql> FLUSH PRIVILEGES;
2:修改mysql库user表,将mos对应的host update.
然后别忘了FLUSH PRIVILEGES
这样mysql -u mos -p 或者-h 跟上主机名localhost mos都可以登录了。
mysql> select host,user,password from user;
+-----------+-------+-------------------------------------------+
| host | user | password |
+-----------+-------+-------------------------------------------+
| localhost | root | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
| mos | root | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
| 127.0.0.1 | root | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
| ::1 | root | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
| localhost | | |
| mos | | |
| mos | ctoms | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
|
localhost | ctoms | *40C208B13EE1FDE55495D0C6F9E791F7E40E6494 |
+-----------+-------+-------------------------------------------+
8 rows in set (0.00 sec)
mysql>
bash-4.3# mysql -u mos -p'mos' -h mos
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 75
阅读(851) | 评论(0) | 转发(0) |