[expert] MySQL _answers_ needed
Ok, after applying every "fix" for this i can find, i need an answer. i get the following when trying to connect to mysql Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ive tried the following "fixes": chmod 775 /var/lib/mysql/ chmod o+t /tmp and I've made sure mysqld is running: [root@localhost mysql]# mysqladmin -p version Enter password: mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.42 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 19 hours 31 min 8 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.000 [root@localhost mysql]# I'm trying to connect with mysqlgui because i'm a wuss FileMakerPro convert. I installed MySQL on Mandrake 8.1 with the rpm. I installed mysql-server-3.23.41-1 along with the mysql shown. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [expert] MySQL _answers_ needed
On Sunday 03 February 2002 14:25, you wrote: > Ok, after applying every "fix" for this i can find, i need an answer. > > i get the following when trying to connect to mysql > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > Try using the hostname (or FQDN) instead of 'localhost' in the configuration file. And I highly recommend phpMyAdmin - http://phpmyadmin.sourceforge.net/ -- Live fast, die young, you're sucking up my bandwidth. -- J.P. Pasnak, CD [EMAIL PROTECTED] http://www.warpedsystems.sk.ca Kernel version: 2.4.17-13mdk Current Linux uptime: 17 hours 26 minutes. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [expert] MySQL _answers_ needed
On Sun, 2002-02-03 at 15:02, J.P. Pasnak wrote: > On Sunday 03 February 2002 14:25, you wrote: > > Ok, after applying every "fix" for this i can find, i need an answer. > > > > i get the following when trying to connect to mysql > > > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > > Try using the hostname (or FQDN) instead of 'localhost' in the configuration > file. ok, I added .localdomain (home machine) to the localhost and now I'm getting: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) even though I've set my root user password with the following: # mysqladmin -u root -p password '**' one step forward, two back. Also... > > And I highly recommend phpMyAdmin - http://phpmyadmin.sourceforge.net/ > > I would, except apach doesn't want to install- keeps complaining it needs stuff that is already installed Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [expert] MySQL _answers_ needed
On Sun, 2002-02-03 at 14:25, Jason Guidry wrote: > Ok, after applying every "fix" for this i can find, i need an answer. > > i get the following when trying to connect to mysql > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > I'm trying to connect with mysqlgui because i'm a wuss FileMakerPro > convert. I installed MySQL on Mandrake 8.1 with the rpm. I installed > mysql-server-3.23.41-1 along with the mysql shown. I guess the first thing I would try is to connect using the basic command-line client: [dave@sildara rezzphp]$ mysql -u root -p database_name Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> If you can establish a connection that way, then you know it's a problem with the GUI client (incorrect config, whatever). If you still can't connect even with the command line client, then it would seem to be a problem with mysql or maybe system file permissions. I don't know enough about mysql to properly troubleshoot it, but the above advice seemed to me to be common sense stuff. Dave -- Beware the wrath of dragons, for you are crunchy, and good with ketchup. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [expert] MySQL _answers_ needed
On Sun, 2002-02-03 at 17:45, Dave Sherman wrote: > On Sun, 2002-02-03 at 14:25, Jason Guidry wrote: > > Ok, after applying every "fix" for this i can find, i need an answer. > > > > i get the following when trying to connect to mysql > > > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > I'm trying to connect with mysqlgui because i'm a wuss FileMakerPro > > convert. I installed MySQL on Mandrake 8.1 with the rpm. I installed > > mysql-server-3.23.41-1 along with the mysql shown. > > I guess the first thing I would try is to connect using the basic > command-line client: > > [dave@sildara rezzphp]$ mysql -u root -p database_name A-ha! i think i need to mount a mirror to the side of my monitor so I will always be able to see what the problem is. I hereby promise to check md5 sums on all of my rpm downloads _BEFORE_ posting dumb-a?? questions to the list, maybe even before I install rpms. I'm downloading MySQL again now and I'll post again when I screw up again. thanks for the help. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [expert] MySQL _answers_ needed
On 2/3/02 2:25 PM, "Jason Guidry" <[EMAIL PROTECTED]> wrote: > Ok, after applying every "fix" for this i can find, i need an answer. > > i get the following when trying to connect to mysql > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > Make sure that this is the correct location of mysql.sock. Some installations install mysql.sock in a subdirectory of the mysql.sock depending on the paramaters of the installation. The RPM you are using may have been produced of a build that puts the mysql.sock in a different directory than the default /tmp/mysql.sock. I had this same problem when I tried to compile MySQL on an OSX system. Good Luck, SA Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com