Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
victor |
| Subject: |
please help: can only connect as root via mysql.sock |
| Date: |
04-21-2000 04:36PM |
i have tried the suggested solutions at mysql.com, but am still looking for answer.
problem:
as root, i can connect to all databases via sockets and tcpip, but as other users or anonymous, i can only connect to databases vi TCP/IP. this includes the test database.
when i attempt to connect to the test database:
% mysql test
i receive the error:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
however, i can connect via TCP/IP using:
% mysql -h '127.0.0.1' test
and this is the weird part:
as root i can connect via sockets and TCP/IP, no problem.
any ideas would be greatly appreciated.
my environment:
Caldera eDesktop Linux 2.4 (2.2.14)
mysql 3.22.32, installed via rpm
skip_networking is OFF
cheers,
victor
|
Other posts in this thread:
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
