PDA

View Full Version : How connect to MySQL server?


Kens
01-20-2000, 12:48 PM
I've been searching around here trying to find out how to connect to MySQL server -- without success.

Tried telnet and got this error message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
[nbsp](111)

Can someone please point me in the right direction? Thanks. Ken

urban
01-20-2000, 02:13 PM
To what server do you telnet?[nbsp][nbsp]What do you type on the command line?

It depends on where the MySQL server is running and how you are trying to access it...

Provide additional details and someone will likely be able to help.

Kens
01-20-2000, 03:48 PM
Thanks,
Server is SEVEN
At the command line, I typed:
mysql -uuser -ppassword

Justin
01-20-2000, 04:19 PM
You have to specify the host name for the MySQL server. SEVEN has no mysql server on it, as the databases are on "mysql01", the DAS::MySQL server...

</font><font face="Courier" size="3">mysql -uusername -p -hmysql01</font><font face="Verdana, Arial" size="2">

Also - never put your password in plain text on the command line - you should just specify the &quot;-p&quot; and it will prompt for your password.

Hope this helps.

------------------
Justin Nelson
FutureQuest Support

Kens
01-20-2000, 04:48 PM
Thanks.
Tried that, got this:
ERROR 1045: Access denied...

Justin
01-20-2000, 05:07 PM
Access Denied... - could you post the entire error message? I've never seen MySQL spit out &quot;...&quot; before...

Now might be a good time to re-read your MySQL activation letter, and make sure you are using the examples provided within that email - I can assure you that the MySQL server is functioning properly...

Try typing the examples provided in the activation letter and if you still receive error messages, please paste the *exact* message in a post or an email to Support@FutureQuest.net.

------------------
Justin Nelson
FutureQuest Support

Kens
01-20-2000, 07:00 PM
Oops, sorry, still new here. Found the hang-up -- using my regular account password instead of MySQL password. Thanks for your help.