PHP Remote connection Server error.
$host = ' remote server IP ';
$root = ' user name ';
$pwd = ' password ';
$con = @mysql_connect ($host, $root, $pwd);
mysql_query ("Set names ' UTF8 '");
@mysql_select_db ("XS_CQC", $con) or Die (Mysql_error ());
My connection to the local database is normal, but the connection to the remote report this error.
Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)
What does this mean?
------to solve the idea----------------------
Remote connection to MySQL requires authorization from the other side
------to solve the idea----------------------
Link the remote database to the account with remote link permissions
Executing in the database
> GRANT all privileges the database name. * to ' username ' @ '% ' identified by ' password ' with GRANT OPTION;
> FLUSH privileges;
That's it.
------to solve the idea----------------------
No link permissions,
What access permissions are required in the other's MySQL database.
Set the User,host in phpMyAdmin