MySQL: initial config problem

[doni49]

I've installed MySQL on my RasPi. But when I when I try to create a MySQL user, it tells me that I need the root PW. I don't remember ever setting a root PW.

So I TRIED to follow the steps at the following page to be able to run MySQL as a regular user. But when I attempt to start the MySQL service having done so, it fails to start.

http://dev.mysql.com/doc/refman/5.0/en/ ... -user.html

TIA!

[doni49]

Well I finally solved the problem. I figured out how to reset the MySQL root PW.

http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html

The documentation is a little lacking though. I used the section labeled "C.5.4.1.3. Resetting the Root Password: Generic Instructions". It says to restart mysqld using the option "--skip-grant-tables". But I have yet to see a way to do that on the command line. I edited /etc/mysql/my.cnf and added that line (without the two initial hyphens) and then restarted the mysql service. I was able to change the root pw using the instructions provided. Then I removed the skip-grant-tables line from my.cnf and restarted the mysql server again.