That has happened to me before the problem is there
has to be chmod command run in the specific folder to
enbale the mysql user to create the respective .sock
file. You should use the run level editor in Yast and
the script will take care of everything you need.
Good luck.
George
--- Scott Leighton
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
'/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
Can possibly phpMyAdmin be used for this
On Sunday 10 April 2005 1:30 pm, Terje J. Hanssen wrote: through socket the Yast2 installation? troubleshooting?
Terje
*) # cat /var/lib/mysql/mysqld.log 050410 20:54:09 mysqld started InnoDB: The first specified data file ./ibdata1
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
InnoDB: Foreign key constraint system tables created 050410 20:54:15 InnoDB: Started 050410 20:54:15 Fatal error: Can't open privilege
did not exist: tables 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
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca
participants (1)
-
George Stoianov