mysql启动,登陆,关闭

野蛮杀死数据库导致故障案例:

http://blog.51cto.com/oldboy/1431161

http://blog.51cto.com/oldboy/1431172

kill用法详解:

http://www.cnblogs.com/peida/archive/2012/12/20/2825837.html

 

(第三个最好别用)

 

 

改变mysql界面提示符

mysql> prompt \u@TEST \r:\m:\s->
PROMPT set to ‘\u@TEST \r:\m:\s->’
root@TEST 07:37:54->
root@TEST 07:37:55->

(临时生效)

永久:

vim  /etc/my.cnf

[mysql]
prompt=\\u@TEST \\r:\\m:\\s->

 

远程登陆出错

~]# mysql -uroot -p -h 192.168.42.51 -P3306

ERROR 1130 (HY000): Host ‘192.168.42.52’ is not allowed to connect to this MySQL server

http://blog.sina.com.cn/s/blog_4ee4286501000c45.html

 

 

 

Author: YJZ

发表评论

电子邮件地址不会被公开。