Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: How do I specify the MySQL socket file?

by chanakya (Friar)
on Feb 17, 2005 at 05:59 UTC ( [id://431846]=note: print w/replies, xml ) Need Help??


in reply to How do I specify the MySQL socket file?

Do you have a my.cnf file in /etc ..??
what does the "socket" value in the file say..

If you do not have a /etc/my.cnf create one with the following values.
This is the sample configuration on my machine

[client] socket=/tmp/mysql.sock [mysqld] port=3306 socket=/var/lib/mysql/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M [mysqldump] quick Here is typical user option file: [client] # The following password will be sent to all standard MySQL clients #password="password" [mysql] no-auto-rehash set-variable = connect_timeout=2 [mysqlhotcopy] interactive-timeout
Once you write the file, restart Mysql and try connecting to the Database using
mysql -u plankton
If the above command succeeds then you need not worry about connecting to Mysql using Perl

Hope this helps

Good Luck!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://431846]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2024-04-20 02:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found