MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old May 26th, 2000, 12:40 AM
YogiBear YogiBear is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 3 YogiBear User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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

Reply With Quote
  #2  
Old May 26th, 2000, 01:02 AM
rycamor rycamor is offline
Gödelian monster
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Jul 1999
Location: Pembroke Pines, Florida, USA
Posts: 2,300 rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level)rycamor User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 3 Days 3 h 2 m 4 sec
Reputation Power: 44
Were you running as root when you executed mysql_install_db?

Reply With Quote
  #3  
Old May 26th, 2000, 01:58 AM
Julien Julien is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 1 Julien User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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.;(


Reply With Quote
  #4  
Old May 26th, 2000, 03:13 PM
Tech-Guy Tech-Guy is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 1 Tech-Guy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
I get a similar response, I'm being told that the user 'root' cannot access mysql, password = No

Any thoughts?

Reply With Quote
  #5  
Old May 26th, 2000, 06:49 PM
YogiBear YogiBear is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 3 YogiBear User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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?

Reply With Quote
  #6  
Old May 26th, 2000, 10:03 PM
barrrt barrrt is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 4 barrrt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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).]

Reply With Quote
  #7  
Old May 26th, 2000, 10:18 PM
barrrt barrrt is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 4 barrrt User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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

Reply With Quote
  #8  
Old May 30th, 2000, 09:50 AM
YogiBear YogiBear is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2000
Posts: 3 YogiBear User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > someone can help me to run Mysql on my machine?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway