linux（RHEL5.6）安装pdo_mysql出错。提示mysql_querry missing[已解决]

chenyx

mysql没起来,检查下/var/log下的mysql的日志

smallstarli

我还没找到mysql.sock呢。我还少什么包不

chenyx

应该不缺包了.你检查下mysql的日志吧.正常安装mysql-server包就可以启动服务了

smallstarli

130813 20:32:26  mysqld started
130813 20:32:26 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
130813 20:32:26 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
130813 20:32:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
130813 20:32:26  mysqld ended
少的那个东西，不知道是啥

smallstarli

是因为权限没有设置吗

chenyx

报错了.你将mysql-server包卸载了,然后删除/etc/my.cnf以及/var/lib/mysql/目录,重新安装下mysql-server包吧
应该是你以前安装过mysql的软件造成的

smallstarli

亲，我爱死你了。
[root@localhost ~]# service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
130813 20:47:48 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
130813 20:47:48 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK
Filling help tables...
130813 20:47:48 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
130813 20:47:48 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                           [  OK  ]
Starting MySQL:                                            [  OK  ]

smallstarli

贴的有点多了···············我要不要把 php， pdo_mysql， phpmyadmin都装完再回家呀

chenyx

嗯,现在你就可以用mysql命令登陆到mysql服务器里面执行sql命令了

smallstarli

你太聪明了，我还把密码改了