At 1:22 +0000 6/3/04, Nick Mudge wrote:
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.
By "this did not start it", what do you mean by "this"? mysql_install_db?
That's not supposed to start the server. It starts the server only to
install the grant tables, then the server shuts down, as you see above.
What part of the manual are you reading to find out how to start the
server? I recommend this section:
http://dev.mysql.com/doc/mysql/en/Automatic_start.html
I don't know what rcmysql is, but if you provide more
information than "that failed" you might get some assistance
from those who do know what it is. For example, if you get
an error message, please indicate what it is.
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?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
