On 01/28/2011 10:10 AM, Bob Williams wrote:
Almost certainly, yes. You can check if someone is already listening on
port 3306: "netstat -ltn".
Also, "pidof mysqld" will tell you the pid if any running mysqld process. Hurrah! Many thanks, Per, there were two pids. Killed both, server starts OK.
I've learnt a lot, thank you for your patience.
Bob
Bob, Another trick in ~/.my.cnf (if your user and mysql install is secured) is to set your login info in the file (then set the appropriate file permission) to allow you to use mysql without having to provide the '-u user -p' string every time you want to do something. It is very handy. Just add the following to ~/.my.cnf: [mysqladmin] password = yourMySQLUserPass user = yourMySQLUser [mysql] password = yourMySQLUserPass user = yourMySQLUser [mysqldump] password = yourMySQLUserPass user = yourMySQLUser and, of course, replace the yourMySQL... data with the actual values. Then all you need to do is type: mysql <whatever> and you are good to go... -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org