MySQL CC problem

[eConcept-Web]

Hi, how can I correct this error in my MySQL Control Center.

the error is:
[eweb] ERROR 1130: Host 'modemcable056.210-201-24.mc.videotron.ca' is not allowed to connect to this MySQL server

Does I need to install something over the server. My MySQL version is : 4.0.17

thx

 

[klaus]

Lets say that you want to login like root!

Then do the following,

# mysql -h localhost -u root -p
mysql>USE mysql
mysql> SELECT User, Host, Password FROM mysql.user;
+------+-----------+------------------+
| User | Host | Password |
+------+-----------+------------------+
| root | localhost | 234ac |
+------+-----------+------------------+

If there is no other record in host you should add one more record to say something like this
Insert into user(User,Host,Password) values('root','modemcable056.210-201-24.mc.videotron.ca','234ac');
Or the folowing (I thing is bad to connect from everywhere )
UPDATE user SET host='%' WHERE host='localhost' And User='root';
FLUSH PRIVILEGES;

 

[eConcept-Web]

I do this in the SSH session ???

 

[klaus]

Yes this is made by ssh/telnet session, if you cant tell your system admin/host master to add your ip to hosts.

 

[jmstacey]

By default MySQL only allows connection from the localhost (the server itself).

From the user level goto "MySQL Management", click on the database you are trying to connect to.
On the bottom of that page should be a table with the header "Access Hosts"
Add the host you are trying to connect from to that list and you should be set.

 

[eConcept-Web]

thx really much everybody


I love the DirectAdmin community