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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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.
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