Bob Williams wrote:
On Friday 28 Jan 2011 08:37:07 Per Jessen wrote:
Cristian Rodríguez wrote:
El 27/01/11 12:56, Per Jessen escribió:
This means editing /etc/init.d/mysql or stopping and starting the server manually.
No!, you should add load-infile to the mysqld section in /etc/my.cnf
Very true, a much better place.
OK, I'm following all this. What is the syntax for adding load-infile to this file? All the entries seem to be of the form
option = value
Ah. I see 'skip-locking' on a line by itself. So, I just need to add 'load- infile' under that?
Yep, that's it. You can optionally use 'load-infile=0' or 'load-infile=1'.
My other problem has been getting the server running. Because I'd forgotten the root password (I must have set it a long time ago), I've been through various convolutions involving stopping the server, running mysql_safe --skip- grant-tables, and updating the password. Mysql_safe dumps me at a promptless console, which seems to accept input commands, but doesn't honour exit or quit, so I end up killing it by closing the terminal. This doesn't seem very satisfactory, as shown by the fact that the server won't restart. I'm starting and stopping it in Yast > System Services (Runlevel).
http://lmgtfy.com/?q=mysql+server+password+reset http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-... -- Per Jessen, Zürich (0.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org