Link to home
Start Free TrialLog in
Avatar of EdwardPeter
EdwardPeter

asked on

remote host is not allowed to connect to this mysql server

Hi,

Please kindly assist how can we remotly login to mysql ?

running on fedora core 3 (fresh install) everything is default.

how can we change the root (mysql) password? are there commands we need to run to get mysql setup and ready to rock n roll?  :)

I'm on a windows client trying to connect to mysql, error mesasge:remote host is not allowed to connect to this mysql server

thanks.
SOLUTION
Avatar of mensuck
mensuck

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Kani Str
Kani Str
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Cyberstorm22
Cyberstorm22

LOL

I should read my statements before sending them. Well its late here in Autria (2:40 am, so please forgive me)
In 2. i mean: ...login to mysql through mysql-console as root-user

-- Christian from Austria
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

this will give access to user monty with some_pass as thier password to access to mysql from a client like navicat or mysqlfront

the '@%' is a wildcard and therefore you dont have to specify your host ip here.
Hi,

i've installed php5 and mysql in my cloud server.

mysql is get connected in the putty console and as well as heidi sql.

but while using those db credentials in the hosting pages the DB is not get connected. and i couldnt figure out the error message too.

both root access and user access (new user is created and granted all privileges too) for mysql are not connected in the php pages.
but it does in the putty and heidi sql.

the ports 3306, 3307 were opened. in iptables it is set to open.

should i install any connector for mysql in cloud server?

please provide some solutions to connect the mysql db in the php pages.

Thanks in advance,
Rose.