SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I followed the instruction at http://www.webmasterbase.com/article.php?aid=228&pid=44 .

    But at the last few commands, the telnet told me this


    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    [root@www mysql]# bin/safe_mysqld --user=mysqlusr &
    [root@www mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
    010201 02:07:58 mysqld ended

    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    Why does it end automatically?
    I saw the bug page at the mysql.com doc, there is a bug which is caused by "mysqld daemon ended", wonder is this the same.

    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    [root@www mysql]# bin/mysqladmin -u root status
    bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (111)'
    Check that mysqld is running and that the socket: '/tmp/mysqld.sock' exists!

    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    Someone help me!!!! SOS.. Beep beep~~~

  2. #2
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Now, when I type in "mysql", it shows

    [root@www admin]# mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 17 to server version: 3.22.32

    Type 'help' for help.

    mysql>


    But hey, 3.22.32 is the version I am having errors in installing. 3.23.32 is the version that I install without any error, just having error while running it.

    Can someone explain this to me ?

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2001
    Location
    Switzerland
    Posts
    57
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hmm when you have a message "mysqld ended" just after you start it, it means that mysql can't be started but there can be a lot of reasons why it cannot start. i had a similar problem 3 days ago and it was because my hard drive was full so lots of possible reasons but you should first check out the .err file of mysql, located in the data dir (/usr/local/mysql/var in your example). it can give useful infos.

    by the way, on the second example you take from mysql.com, it's just what happens when the mysql server has not been started. that's also the kind of error you'd get on your php pages if you tried to connect to mysql.

    let me know if you have more infos so i can help more


    zEBz

  4. #4
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysql> status
    --------------
    mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

    Connection id: 8
    Current database:
    Current user: root@localhost
    Server version 3.22.32
    Protocol version 10
    Connection Localhost via UNIX socket
    UNIX socket /var/lib/mysql/mysql.sock
    Uptime: 30 min 26 sec

    Threads: 1 Questions: 28 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 3
    --------------

    mysql>


    ==========================================================================================

    [root@www admin]# mysqladmin -p ping
    Enter password:
    mysqld is alive
    [root@www admin]# mysql

    ==========================================================================================

    Does this means that mysql is running on my box ????
    It sounds like it is, but I just want to double check before going on with php and phpadmin and etc ...

    By the way, I know the newest version is 3.23.32 or above, should I update it before installing php? Or maybe, should I ask, should I really update it?

    Mean while, how can I test the mysql without any mysql knowledge? Any command to create the db and test automatically ?
    <Edited by Donovan on 02-02-2001 at 05:35 AM>

  5. #5
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It appears as if MySQL is running properly on your machine at this moment in time.
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.

  6. #6
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the info.

    Anyway, I installed PHP 4.04 successfully as well.

    WOWIE~~~

    Thanks to people in this forum, and WHT who answered, and also Matt, RoH@n for helping me.


  7. #7
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Donovan,

    This is why my tutorial begins with instructions for removing installed versions of PHP and MySQL.

    If you're happy with 3.22, then there's no reason to go to the trouble of installing a newer version. 3.22 is more than adequate for learning purposes.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

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