[root@s39 www]# service mysqld stop
mysqld: unrecognized service
[root@s39 www]# yum install -y mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.arcticnetwork.ca
* updates: mirrors.easynews.com
* addons: centos.arcticnetwork.ca
* extras: mirror.stanford.edu
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.i386 0:5.0.77-3.el5 set to be updated
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Running transaction check
---> Package perl-DBD-MySQL.i386 0:3.0007-2.el5 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================
Package Arch Version Repository Size
===================================================================================================
Installing:
mysql-server i386 5.0.77-3.el5 updates 9.8 M
Installing for dependencies:
perl-DBD-MySQL i386 3.0007-2.el5 base 148 k
Total download size: 300 k
Downloading Packages:
(1/3): php-pdo-5.1.6-23.2.el5_3.i386.rpm | 64 kB 00:00
(2/3): php-mysql-5.1.6-23.2.el5_3.i386.rpm | 85 kB 00:00
(3/3): php-common-5.1.6-23.2.el5_3.i386.rpm | 151 kB 00:00
---------------------------------------------------------------------------------------------------
Total 138 kB/s | 300 kB 00:02
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-common [1/3]
Installing : php-pdo [2/3]
Installing : php-mysql [3/3]
Installed: php-mysql.i386 0:5.1.6-23.2.el5_3
Dependency Installed: php-common.i386 0:5.1.6-23.2.el5_3 php-pdo.i386 0:5.1.6-23.2.el5_3
Complete!
[root@s39 www]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@s39 www]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.1.39-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit
Bye
[root@s39 www]# service mysqld stop
Stopping MySQL: [FAILED]
[root@s39 www]# service mysqld restart
Stopping MySQL: [FAILED]
Initializing MySQL database: WARNING: The host 's39.fsck' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
091016 16:42:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4 294967295
091016 16:42:19 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4 294967295
091016 16:42:19 [ERROR] /usr/libexec/mysqld: unknown variable 'table_open_cache=64'
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/libexec/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
The latest information about MySQL is available on the web at http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
[FAILED]