someone can help me to run Mysql on my machine?

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

Were you running as root when you executed mysql_install_db?

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.;(

I get a similar response, I'm being told that the user 'root' cannot access mysql, password = No

Any thoughts?

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?

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).]

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

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