Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 09-13-2005, 10:41 AM   #1
Registered: Jan 2003
Posts: 50

Rep: Reputation: 15
connecting to a MySQL database

This is so absurd, but i've come to a dead end and don't know what else to do. I'm just trying to connecto a database and the code is correct, the user has all the rights (more then required!!!, since i gave him all the rights to do whatever he wants), in localhost, in server name as in any server!!! i still can't connect? Is there any security issue that my be slipping under my bear?

i use mandriva 10.2, Mysql 4.1 and apache 2.

thanks in advance

Old 09-13-2005, 04:11 PM   #2
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975Reputation: 1975
you've said nothing about you're actually doing... is mysqld even running? are there any errors? can you connect directly througth a terminal?
Old 09-13-2005, 04:29 PM   #3
Senior Member
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690

Rep: Reputation: 51
*Try commenting the line skip-networking in the configuration file my.cnf of mysql. It is located in general in /etc or /etc/mysql.
*Restart mysql and try again.
Old 09-16-2005, 06:34 AM   #4
Registered: Jan 2003
Posts: 50

Original Poster
Rep: Reputation: 15
Sorry for the late reply. I solve it and was so envolved in my work iforgot about you guys

Ok, update:

yes, of course mysqld is running, and i can enter in mysql from terminal and with phpMyAdmin.

there's no problem with my my.cnf... i have that line commented from start. But thanks

Ok the thing is ... i admin my mysql from phpMyAdmin and i think it may have a bug there. I did search the phpMyAdmin home page for this but come out nothing. If i just create the user and grant him the priv's through phpMyAdmin, it wont work!!! although when i browse the database from phpmyadmin, i can see his privs properly. Only granting privs from mysql console i get it to work. Most wierd

Thanks for all you're help


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
probs with connecting to mysql database using php ankscorek Linux - Software 4 08-16-2005 07:40 PM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
Connecting Mysql Database on remote server akamol Programming 4 10-16-2003 11:46 AM
Mysql is not connecting from servlet.But connecting from java, help pls Harish_f Linux - General 0 05-08-2002 03:21 AM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 03:48 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration