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

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Hi Everyone¨: I have Mandrake Linux 7 on my machine, I tried to install Mysql from the rpms cd of Mandrake, I did:
    1)Install all the RPM that begin with MySQl...client, database, libs, etc etc

    2)cd /usr/lib and type mysql_install_db the machine gave me the following message

    Creating Database
    ERROR : can´t connect to local mysql server (111) /usr/bin/mysqladmin : can´t connect to local mysql

    3)when I look at /var/lib there is a /mysql directory, inside this are /mysql and /test directory and localhost.localdomain.log but there aren´t any grant tables!!!!

    finally if I tried /usr/bin/ safe_mysqld & it doesn´t work

    What can I do for try using mysql on my machine and use it at the same time server and client?

    thank you in advance
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    Were you running as root when you executed mysql_install_db?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    I got the same problems please Help US...
    My mysql.sock,neither mysqld.pid are not create 'cause none session have been started since the first time.
    HELP.;(

  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    I get a similar response, I'm being told that the user 'root' cannot access mysql, password = No

    Any thoughts?
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Thanks for your response rycamor and Tech-guys.

    Yes, I did mysql_install_db as root, so I changed to a normal user and write the comand again...

    I received some messages about privileges, so I changed the owner of /var/lib/mysql to a normal user and give rwx to everyone in that directory, after that like a normal user I type mysql_install_db but it doesn´t work this time give a lot of messages like this:

    /bin/chown: /var/lib/mysql/mysql: operation not permitted
    /bin/chown: /var/lib/mysql/mysql/db.frm: operation not permitted
    /bin/chown: /var/lib/mysql/mysql/db.ISM: operation not permitted
    /bin/chown: /var/lib/mysql/mysql/host.frm: operation not permitted
    /bin/chown: /var/lib/mysql/mysql/host.ISM: operation not permitted
    etc. etc.

    /usr/sbin/mysqld : Shutdown complete

    What another thing I did bad?
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    YogiBear,

    I am not sure if I understand correctly, but are you trying to run mysql_install_db as non root? If so, you should not need to. Try this:

    1. install mysql db structure. Run as root:

    mysql_install_db

    2. start mysql server. Run as root:

    /etc/rc.d/init.d/mysql start

    At this point you should be able to connect to mysql... as root try:

    mysql mysql

    this should start mysql client using db mysql.That's all I had to do to get it to work on Mandrake 7.0. Also, read the SQL admin intro here on devshed - it's very helpful.

    Good luck,
    barrrt



    [This message has been edited by barrrt (edited May 26, 2000).]
  12. #7
  13. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    Tech-Guy,

    You will get that message if you try to connect to mysql server without specyfing the password. When you first install mysql there is no password for root (sql root, not linux root) and you can use just:

    mysql mysql

    to connect. But once you set a password, you need to connect like this:

    mysql mysql -p

    ...and you will be asked for password.

    barrrt
  14. #8
  15. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Thank you to all peoble out there who have been help me with the problem explain above.... I did the following in order to mysql to work:

    Like normal user run mysq_install_db but I receive again the message I told, so I wrote mysql mysql to turned the server on and after that mysql_install_db and this time all the gran tables were created in the right way......

    Best Regards

Similar Threads

  1. Missing icons, taskbar, start menu
    By Richard747 in forum Windows Help
    Replies: 31
    Last Post: July 21st, 2005, 07:40 AM
  2. mysql server on different machine than hosting
    By metro in forum MySQL Help
    Replies: 6
    Last Post: February 18th, 2003, 11:34 PM
  3. Anybody run Apache 2.x (fine) on a WIN32 machine?
    By chali in forum Apache Development
    Replies: 4
    Last Post: August 6th, 2002, 11:39 PM
  4. No idea on how to connect to mySQL, please help
    By darthmahon in forum MySQL Help
    Replies: 1
    Last Post: January 7th, 2002, 05:31 AM
  5. anyone can run mysql on my server,
    By anna in forum MySQL Help
    Replies: 1
    Last Post: May 27th, 2000, 05:48 AM

IMN logo majestic logo threadwatch logo seochat tools logo