[SLE] Getting MySQL working

From: Nick Mudge (mudgix_at_hotmail.com)
Date: 06/03/04

  • Next message: Ed Harrison: "Re: [SLE] SuSE 9.1 successes" 
    To: suse-linux-e@suse.com
Date: Thu, 03 Jun 2004 01:11:41 +0000

    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/ 

    -- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com
  • Next message: Ed Harrison: "Re: [SLE] SuSE 9.1 successes"

    Relevant Pages

    • Re: MySQL permission
      ... > you after installing the initial database you would not have this problem. ... I just gave the command "sudo yum install mysql-server". ... on my MySQL server, and have not had any problems on that score. ...
      (comp.os.linux.misc)
    • Re: ASP, PHP, and HTML forms problems
      ... >development 2003 server with PHP installed as ISAPI. ... MySQL is the database ... >real server after installing MySQL (PHP was already installed because we have ...
      (microsoft.public.inetserver.iis)
    • Re: using mysql client to read a file to create a table in a database in a mysql server
      ... so I wonder what is the syntax of the mysql command, ... Also because I am using mysql server 4.1.16 the installed client ... When you issue a mysql statement from the command line, ... I know that I can create the table by typing the commands in to the ...
      (comp.lang.ruby)
    • Re: MySQL/PHP web app on SBS 2003? (intranet only)
      ... Although not on an SBS Box, I have run SQL Server, MSDE, PostgreSQL, ... MySQL and even Oracle lite all concurrently on Windows Servers ... Have a look here in relation to installing PHP on the system. ...
      (microsoft.public.windows.server.sbs)
    • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
      ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
      (Fedora)