当前位置:Gxlcms > mysql > Linux下Mysql使用问题总结

Linux下Mysql使用问题总结

时间:2021-07-01 10:21:17 帮助过:55人阅读

1、找不到mysql服务 mysqld: unrecognized service 解决办法 yum install mysql-server 2、报错:java.sql.SQLException: null, message from server: Host 'S1PA124' is not allowed to connect to this MySQL server 解决办法 GRANT ALL PRIVILEGES ON *.*

1、找不到mysql服务

mysqld: unrecognized service
解决办法
yum install mysql-server
2、报错:java.sql.SQLException: null, message from server: "Host 'S1PA124' is not allowed to connect to this MySQL server"

解决办法

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH   PRIVILEGES;

3、修改mysql密码

#/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>
4、mysql需要安装以下几个服务
yum install mysql 
yum install mysql-server 
yum install mysql-devel

5、Mysql刚安装好默认密码为空

[root@fk01 ~]# mysql -uroot -p //回车,再回车


参考:http://youyizhimen.blog.163.com/blog/static/17091726720114654326691/

6、修改mysql的dataDir

(1)停止mysql:service mysqld stop

(2)创建转移动的数据目录:mkdir -p /app/mysql/data

(3)将mysql默认的数据目录移到新目录下:mv /var/lib/mysql /app/mysql/data

(4)创建软链接:ln -s /app/mysql/data/mysql /var/lib/mysql

(5)修改/app/mysql的权限,即是把该目录的权限给mysql用户:chown -R /app/mysql

(6)启动mysql服务:service mysqld restart

(7)错误总结:

[root@fk01 var]# service mysqld restart
Stopping MySQL:  [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:  [FAILED]
查看mysql的日志

[root@fk01 log]# tail -200 mysqld.log
150304 14:13:40  mysqld started
150304 14:13:40  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
150304 14:13:40  mysqld ended
从上面可以看出与mysql用户的权限有关,解决办法:chown -R /app/mysql

7、复制mysql的数据库到另一台机器上

源数据库名:source_db 用户名:root 密码:123456
目标数据库名:target_db 用户名:root 密码:123456 所在主机:192.168.1.100

在目标数据库授权给源机器的访问权限

grant all privileges on target_db.* to root@192.168.1.101  identified by '123456';

进到源数据库的数据目录执行

mysqldump source_db -uroot -p123456 --opt | mysql target_db -uroot -p123456 -h 192.168.1.1

人气教程排行