473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Host is not allowed to connect

Hello.
I have mysql working. I have change my hostname name(until now i used
localhost) and i cannot connect.

# mysql -u mail -p -h server.domain.com
Enter password:
ERROR 1130: Host '196.26.0.3' is not allowed to connect to this MySQL
server

# mysqladmin -u root -h server.domain.com -p password 'pass'
Enter password:
mysqladmin: connect to server at 'server.domain.com' failed
error: 'Host '196.26.0.3' is not allowed to connect to this MySQL
server'

How i can to solve this ?

Thanks.
Jul 20 '05 #1
1 33974
jose wrote:
# mysql -u mail -p -h server.domain.com
Enter password:
ERROR 1130: Host '196.26.0.3' is not allowed to connect to this MySQL
server


First you need to connect to your database from localhost

mysql -u root -p

Then you need to issue this command, or similar to add privileges to
connect from other servers. It is recommended to give as limited access
as possible for security reasons. And don't give root user remote access
unless you really have to.

grant all on somedatabasename.* to mail@'196.26.0.3' identified by
'password';

This will give access to connect from that ip address to the database.
You can also use mail@'%' which will allow connections from anywhere,
but that is not recommended. Or mail@'196.26.0.%' which will allow
connection if 3 first numbers of the ip address are 196.26.0

See MySQL manual for complete syntax for grant.
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: photoelectric | last post by:
When trying to run the below script on an apache/1.3.26 with mysql and php I get the following error message: Warning: mysql_connect() : Access denied for user: 'nobody@software-ece.rutgers.edu'...
1
by: Chuck | last post by:
Trying to connect from 1 linux box to another. A to B. The B.user table has a host IP entry and a host name entry for mach A. "mysql -h machB.com -u chuck" returns: ERROR 1130: Host...
30
by: aka | last post by:
Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB...
0
by: Clodoaldo Pinto | last post by:
Can't connect to postgresql server php error log message: PHP Warning: pg_connect() : Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
2
by: Martin | last post by:
Hi all. I have a fully functional page hosted on my PC that uses PHP and connects to MySQL on my PC to generate it's code. I now have some web hosting available which includes both PHP and...
3
by: cubano | last post by:
Hi there: I need URGENT help about this .. I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same...
2
by: mmr315 | last post by:
this is the code i had written in php to connect to mysql ======================================== <? php class Database { var $database_name; var $database_user; var...
5
by: db2admin | last post by:
hello, I am wondering if i can install db2 connect product on a AIX server which already has db2 ese installed on it ? regards,
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.