Hi, I am trying to get MsSQL working. I can't get the server to start. I tried typing in mysql_install_db and got the following response: linux:/home/nick # mysql_install_db Installing all prepared tables 040602 5:54:02 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /usr/bin/mysqlbug script! But this did not start it. I tried typing in rcmysql start but that failed. I can't get the service started in the first place so I can't add any passwards to any accounts. I installed the mysql with the suse 9.1 pro cd. I am thinking that I should reinstall my mysql. But I don't know how to do that. Can someone please tell me how to fix this or how to reinstall it? Nick _________________________________________________________________ Get fast, reliable Internet access with MSN 9 Dial-up now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/
* Nick Mudge
I am trying to get MsSQL working. I can't get the server to start.
How do you know that you cannot get the service to start? what is the result of: /usr/sbin/rcmysql status if it is *not* 'running': /usr/sbin/rcmysql start report back to the list... -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org HOG # US1244711
In a previous message, "Nick Mudge"
/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h linux password 'new-password' [snip]
I can't get the service started in the first place so I can't add any passwards to any accounts.
Have you actually issued the commands above, which were included in the instructions you quoted? You don't need mysql running for this to work. Indeed, until you do this, mysql won't start (as you noted). John -- John Pettigrew Headstrong Games john@headstrong-games.co.uk Fun : Strategy : Price http://www.headstrong-games.co.uk/ Board games that won't break the bank Knossos: escape the ever-changing labyrinth before the Minotaur catches you!
participants (3)
-
John Pettigrew
-
Nick Mudge
-
Patrick Shanahan