On Sunday 10 April 2005 1:30 pm, Terje J. Hanssen wrote:
Scott Leighton wrote:
Sounds like it is not running. It installs with no root password, so unless you changed it, you should be able to simply type
#mysql
as root and access the db.
Still the same error occures:
# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I verified that '/var/lib/mysql/mysql.sock' did not exist. Below is however the content of /var/lib/mysql/mysqld.log *) And where is e.g. the boot log file located to verify the messages I saw regarding startup of MySQL?
Have I missed some steps that need to done after the Yast2 installation? Can possibly phpMyAdmin be used for this troubleshooting?
Terje
*) # cat /var/lib/mysql/mysqld.log 050410 20:54:09 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050410 20:54:10 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050410 20:54:11 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050410 20:54:12 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050410 20:54:15 InnoDB: Started 050410 20:54:15 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050410 20:54:15 Aborting
050410 20:54:15 InnoDB: Starting shutdown... 050410 20:54:19 InnoDB: Shutdown completed 050410 20:54:19 /usr/sbin/mysqld-max: Shutdown Complete
050410 20:54:19 mysqld ended
I dunno, it looks like maybe a bad install. Almost like your db didn't get built. When the RPM is installed, it is supposed to run /usr/bin/mysql_install_db which creates the basic db at /var/lib/mysql/mysql Do a dirlist of /var/lib/mysql/mysql and see if you have a bunch of table files there. If you don't, then I have no clue what is going on, I'd probably try running /usr/bin/mysql_install_db to see if that solves it. Also, what is in your /etc/my.cnf configuration file? Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.8-24.14-default x86_64