#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Hi,

    I'm running Linux-Mandrake 7.0 (Air) and installed MySQL when I setup Mandrake. Now, I'm attempting to run MySQL but I don't believe it is running. How can I check this, and if it is not running how can go about having it start up automatically and use it with Apache and PHP or PERL.

    If there's a tutorial or something that someone point me to it would be much appreciated, as I haven't found the MySQL docs to be much help. I'm not even sure if everything is installed properly.

    If anyone can help it would be much appreciated, thanks.

    Chris

    ------------------
    ------------------
    Chris Rose
    crose@teamit.net
  2. #2
  3. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
    You need to run mysql_install_db script. It might be found at /usr/local/mysql/bin/.
    Then you may run safe_mysqld to start Mysql.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Thanks,

    I gave it a try and the mysql_install_db seemed to run properly but I recieve the following message when I run safe_mysql.

    "Starting mysqld demon with databases from /var/lib/mysql
    mysqld demon ended

    And if I try anything else I get this message.

    mysqladmin: connect to server at '' failed; error: 'Can't connect to local mysql server (111)'

    Chris

    ------------------
    ------------------
    Chris Rose
    crose@teamit.net
  6. #4
  7. No Profile Picture
    freebsd
    Guest
    Devshed Newbie (0 - 499 posts)
    Be sure to setup a hostname correctly. It is something like "foo.bar.com".
    Check and see if this script "mysql.server" is found. If so, copy it to your local starup dir.
    Any pid file in /var/run/mysqld.pid or /usr/local/mysql/var/mysqld.pid?

    Do not run mysqladmin until you setup your hostname correctly.

Similar Threads

  1. mysql database setting
    By digitalerr0r in forum PHP Development
    Replies: 1
    Last Post: January 12th, 2004, 03:06 PM
  2. Can't connect to MySQL server remotely
    By bper in forum MySQL Help
    Replies: 2
    Last Post: October 2nd, 2003, 03:09 PM
  3. MySQL: Trouble Setting Permissions
    By chino3000 in forum MySQL Help
    Replies: 3
    Last Post: August 10th, 2003, 09:21 AM
  4. MySQL: Problem with setting privledges
    By chino3000 in forum Beginner Programming
    Replies: 3
    Last Post: August 3rd, 2003, 03:04 PM
  5. Setting up mySQL on OpenBSD -- Cry For Help
    By circuit in forum MySQL Help
    Replies: 2
    Last Post: October 3rd, 2000, 05:36 AM

IMN logo majestic logo threadwatch logo seochat tools logo