摘要:
启动失败,查看日志:Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist该问题和安装数据文件时的权限有关,在mysql安装目录下,重新执行一次scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data,这里指定下数据文件的目录,然后重启,问题解决 阅读全文
posted @ 2012-09-27 16:56
mysql dba
阅读(490)
评论(1)
推荐(0)
摘要:
启动时报:error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory这是由于libaio库没有安装,可以执行:yum install libaio安装完后重新启动mysql,问题解决 阅读全文
posted @ 2012-09-27 16:50
mysql dba
阅读(990)
评论(0)
推荐(0)
摘要:
此次安装的为mysql5.5,安装在linux服务器上,具体安装步骤如下:1.新建mysql用户组和用户groupadd mysqluseradd -r -g mysql mysql2.下载mysql,解压后用符号连接至mysql,最新的可以去http://www.mysql.com上下载cd /usr/localwget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.27-linux2.6-x86_64.tar.gztar zxvf mysql-5.5.27-linux2.6-x86_64.tar.gz ln -s mysql-5.5. 阅读全文
posted @ 2012-09-27 16:01
mysql dba
阅读(298)
评论(0)
推荐(0)
浙公网安备 33010602011771号