Visit The New, Modern Unix Linux Community


MySQL server connetction problem


 
Thread Tools Search this Thread
Operating Systems Linux MySQL server connetction problem
# 1  
MySQL server connetction problem

Hello,thanks for your help.
I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this?

Thanks again!
# 2  
MySQL is usually used in a networkless fashion -- connecting through TCP/IP is disabled, only the UNIX domain socket is allowed. If you wish to enable TCP/IP, try commenting out the "skip networking" line in your my.cnf then restarting the MySQL server.

Alternatively, if networking is not disabled, keep in mind that MySQL accounts are not just per username, they're per location as well! Each user can have multiple rows in the user table with different characteristics -- you can give the same account different permissions when logged in from different places! -- and if there's none that allows your IP, then you won't get in.
# 3  
Thanks,but how can I config the my.cnf ?

I need your help,my E-mail address is "xxxxx@xxxx",can i add your MSN?

Last edited by cbkihong; 08-26-2006 at 05:31 AM..
# 4  
Do not post email addresses in a question, it is against the rules. The solutions here are supposed to help everybody. No, you may not harass me on MSN.

You edit my.cnf by... editing my.cnf. It's a text file, that you edit using a text editor, like vi or nano. The file may be placed under /etc/my.cnf, /etc/mysql/my.cnf, or something like that; it can vary from distribution to distribution. After you edit the configuration file, you restart the mysql server with something like
Code:
/etc/init.d/mysqld restart

The exact command may vary from distribution to distribution.
# 5  
Corona688, I think you're thinking of Postgres. MySQL usually installs by default listening on port 3306. This simply doesn't do anyone any good because, by default, the only users within MySQL are assigned to localhost.

lancepanda, you need to add a user for the IP you want to conenct from to MySQL. Log into the machine MySQL is running on, then:
Code:
If you haven't added any MySQL users yet:
$ mysql 
Otherwise:
$ mysql -uADMIN_USER -pMY_PASSWORD

mysql>GRANT ALL PRIVILEGES ON database.* TO your_username@'123.123.123.123' IDENTIFIED BY 'your_password' WITH GRANT OPTION;

mysql>exit;

Replace ADMIN_USER with the username of someone with authority to create new users, database with the database you want to connect to (or * for all), your_username and your_password with the proper values and 123.123.123.123 with your IP address. Be sure to leave the single quotes where they are as well as the semicolon at the end. Optionally, you may limit the privileges by replacing "ALL" with a comma delimited list of privileges (see the mysql manual for more information).

I'll also suggest you use The MySQL Control Center if you're not already. It's not version 1 yet, but beats The MySQL Administrator/Query Browser combo hands down - plus it makes user administration on your MySQL server very straightforward.

Also, as Corona688 said: The answers given here are used by other people in your same situation and you really should go back and edit your email address out of that post.

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #35
Difficulty: Easy
The IP address 127.0.0.1 is also called 'localhost'.
True or False?

8 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Mysql for HP-UX server

Gd evening I am trying to run my website made in php-mysql on a HP-UX system but dont know how to install and run services of Mysql. Kindly provide appropriate solution. thanks in advance. (1 Reply)
Discussion started by: kumar.ashishcs
1 Replies

2. UNIX and Linux Applications

MySQL optimization or why the server is worsened

Hello Please advise me how can I optimize my MySQL server. Or advise which way to look. Maybe someone had similar problems? Over the past two weeks the MySQL server dropped 2 times. I began searching for ways to optimize the server. Overall the picture like that: There is a separate... (2 Replies)
Discussion started by: sergibondarenko
2 Replies

3. Emergency UNIX and Linux Support

New centos dedicated server - cant get mysql working

Hi all, I installed centos 5, with LAMP. httpd is working fine, ssh, ftp all working ok. But, when I try to use mysql its not, when I give the command mysql I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (4 Replies)
Discussion started by: lawstudent
4 Replies

4. Linux

mysql server start issue

Hi, I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6.. I would like to start the server. But there is no mysql file in this location /etc/init.d/ Please advice how to start the server now !! Thnaks, Mani (5 Replies)
Discussion started by: Mani_apr08
5 Replies

5. Web Development

MySQL Server Crashing need Help

Hi, we have some problem with mysql high cpu , would like some help with MySQL Tuning here are the mysqltuner & tuning-primer details mysqltuner: # mysqltuner >> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net> >> Run with '--help' for additional options and output filtering --------... (1 Reply)
Discussion started by: cataplexy
1 Replies

6. Shell Programming and Scripting

Trying to connect MYSQL server from HP-UX

Hi everyone, I have an urgent requirement to get some table data from Linux-MYSQL server from HP-UX with oracle database.Is there any way we can get connected through Shell script from HP-UX and issue select on mysql to get some table data? Please help me out. (7 Replies)
Discussion started by: kashik786
7 Replies

7. Shell Programming and Scripting

Mysql problem

No help guys??? :( Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file... so the first move would be, to access the mysql interface right? hence... #! /usr/bin/ksh echo "Job Begin: " `date` ... (1 Reply)
Discussion started by: 12yearold
1 Replies

8. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

Featured Tech Videos