mysql 5.5二进制安装包初始化报错

回复 收藏

初始化代码报错的代码, 请各位帮忙解答下吗

./scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql

170102 15:24:36 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.

170102 15:24:36 [Note] /usr/local/mysql//bin/mysqld (mysqld 5.5.53) starting as process 1801 ...

170102 15:24:37 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type tex

t, found type char(64).ERROR: 1136  Column count doesn't match value count at row 1

170102 15:24:37 [ERROR] Aborting

170102 15:24:37 [Note] /usr/local/mysql//bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in

/data/mysql/ for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/mysql//bin/mysqld --skip-grant &

and use the command line tool /usr/local/mysql//bin/mysql

to connect to the mysql database and look at the grant tables:

    shell> /usr/local/mysql//bin/mysql -u root mysql

    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log

gives you a log in /data/mysql/ that may be helpful.

Please consult the MySQL manual section

'Problems running mysql_install_db', and the manual section that

describes problems on your OS.  Another information source are the

MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before submitting a bug report

at http://bugs.mysql.com/

2017-01-02 15:31 举报
已邀请:

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: