how to automate mysql cmd?

[Delilah]

I have an /etc/my.cnf file configured with the options
socket=/var/lib/mysql/mysql.sock
datadir=/export/disk1/mysql_db

I su to the user mysql from root and run
$>mysql --sockets=/var.... --datadir=/exp... -u root
This works fine.

Running $>mysql without the options it fails as it goes back to the default socket and datadir settings.

How can I get these settings to be the defaults?
Any help greatly appreciated. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Sague]

The my.cnf file has a number of "sections", introduced by lines like "[mysqld]" or "[mysql]". The config entries within the section apply to the program of the corresponding name. You need to define the socket and datadir in both the [mysqld] and [mysql] sections.

And', both the server and the client need to agree on the location of the socket file, so they can use that file for locally-optimized interprocess communication. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --