Can't create or write to file "MYSQL ERROR"

[williams_k]

Hi

If you are getting the above mentioned given error then you have to make some kind of necessary changes in your my.cnf files. You have to make the necessary changes such as
First of all you have to get the required files as follows which is "my.cnf"
Then you have to edit the file by going in to the /etc/my.cnf
by following command
-------------------------
vi /etc/my.cnf
-------------------------

and the required change the MySQL variable

make sure you open-files-limit to some value that is much more higher than its given default value and this should resolve the error.

[rocky123]

Thanks William

Still i have some query regarding this part is like Could you tell us how to setup proper MySQL client program on remote machine first?
As far as I now, even if we ONLY install MySQL client program on remote machine, it will generate a my.cnf file. Whenever you issue mysql command on remote machine, this file will be consulted and thus, the client will attempt to connect to a non-exist local MySQL sever rather than your remote server.

[Jeffrey]

To be very honest, you don’t need to setup my.cnf for client configuration. All you need to do is specify remote mysql host with –h option.

For example to connect remote mysql server called dbserver.nixcraft.in you need to type command as follows:

$ mysql –u vivek –h dbserver.nixcraft.in -p
----------------------------------------------------------------------------
OR if you with to use MySQL server ip address (xxx.xxx.xxx.xxx):
----------------------------------------------------------------------------
$ mysql –u vivek –h xxx.xxx.xxx.xxx -p

This will defiantly gonna work for you.