容器技术交流

 找回密码
 立即注册
查看: 5186|回复: 2

阿里云上安装完后不能连不上mysql

[复制链接]
发表于 2012-5-8 16:21:19 | 显示全部楼层 |阅读模式
访问:8888 提示Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
这是错误文件
cat AY1205081001227266dd1.err
120508 15:59:57 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 15:59:58 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 15:59:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 15:59:58 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/home/mysql_data/AY1205081001227266dd1.pid' (Errcode: 13)
120508 15:59:58 [ERROR] Can't start server: can't create PID file: Permission denied
120508 15:59:58 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
120508 16:00:00 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 16:00:00 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 16:00:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 16:00:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120508 16:00:00 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
120508 16:01:10 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 16:01:10 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 16:01:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 16:01:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120508 16:01:10 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
120508 16:01:13 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 16:01:13 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 16:01:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 16:01:13 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120508 16:01:13 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
120508 16:04:37 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 16:04:37 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 16:04:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 16:04:37 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120508 16:04:37 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
120508 16:04:40 mysqld_safe Starting mysqld daemon with databases from /home/mysql_data
120508 16:04:40 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
120508 16:04:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120508 16:04:40 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120508 16:04:40 mysqld_safe mysqld from pid file /home/mysql_data/AY1205081001227266dd1.pid ended
[root@AY1205081001227266dd1 mysql_data]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

发表于 2012-10-3 21:30:08 | 显示全部楼层
请问这位朋友解决了吗?我的也是这样的问题,有人知道怎么解决吗?不胜感激
 楼主| 发表于 2012-10-31 14:13:46 | 显示全部楼层
后来重装解决了
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Archiver|URLOS ( 粤ICP备18087780号 )

GMT+8, 2025-7-4 03:49 , Processed in 0.030189 second(s), 18 queries .

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

快速回复 返回顶部 返回列表