Find the answer to your Linux question:
Results 1 to 3 of 3
The following is what I receive when attempting to run mysql_install_db . Code: [root@webserver mysql]# mysql_install_db Installing all prepared tables 040702 14:57:43 Warning: Asked for 196608 thread stack, but got ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2004
    Posts
    3

    MySQL installation problem on RedHat9


    The following is what I receive when attempting to run mysql_install_db.

    Code:
    [root@webserver mysql]# mysql_install_db
    Installing all prepared tables
    040702 14:57:43  Warning: Asked for 196608 thread stack, but got 126976
    040702 14:57:43  /usr/sbin/mysqld: Shutdown Complete
    
    
    To start mysqld at boot time you have to copy support-files/mysql.server
    to the right place for your system
    
    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 webserver password 'new-password'
    See the manual for more instructions.
    
    NOTE&#58;  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 start the MySQL daemon with&#58;
    cd / ; /usr/bin/mysqld_safe &
    
    You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory&#58;
    cd sql-bench ; perl run-all-tests
    
    Please report any problems with the /usr/bin/mysqlbug script!
    
    The latest information about MySQL is available on the web at
    http&#58;//www.mysql.com
    Support MySQL by buying support/licenses at https&#58;//order.mysql.com
    
    &#91;root@webserver mysql&#93;#

    How can I solve the error at the top and get mysql to create the tables, allowing me to launch it?

    Thanks, it's been bugging me all day!
    -- DJ

  2. #2
    Just Joined!
    Join Date
    Jul 2004
    Posts
    3
    Hmm, I completely forgot...

    If I do a ps aux | grep mysqld I get:
    root 2659 0.0 0.1 3576 620 pts/0 S 15:06 0:00 grep mysqld

    So, it looks like mysql is running.
    If I try to do anything else with mysql I get

    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    If I do /etc/init.d/mysql start, and do a ps aux | grep mysqld I'm presented with a dozen instances of mysqld.

    Edit again!: Oh, and there is no file called mysql.sock in /var/lib/mysql

    Thanks guys, this is really bugging me.
    -- DJ

  3. #3
    Just Joined!
    Join Date
    Jul 2004
    Posts
    3
    Yay!
    After 2 hours of searching I found a solution!


    http://www.sitepoint.com/forums/showthread.php?t=169912

    I basically had to run:
    ln -s /var/lib/mysql/mysql.sock mysql.sock

    Weird
    -- DJ

  4. $spacer_open
    $spacer_close

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •