Connection to MYSQL inside LAN

[ly9cs]

Hello
I am running FREESCO 0.3.4
This is my system reporthttp://www.schultze.nu/report.txt

On my inside LAN I have a MYSQL 5.5 running and this I would like to access from my Apache in FREESCO.
I would be happy if I could send some PHP to MYSQL to access the DB:s running there but I have not figured how to jet?

I have changed the php.ini and added the MYSQL server.
Then tried to do a php-script to see if there is any connection
I found this script

Code: Select all

<?php
// we connect to example.com and port 3307
$link = mysql_connect('mysql.inet:3306', 'root', 'MySecretPassWORD!!');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

// we connect to localhost at port 3307
$link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>


The return form my FREESCO is
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Can some one perhatps tell me what I am doing wrong?
Is this possibel?
What do I need to change?
Do I need change the port on my FREESCO to admit the 3306 to MYSQL?


I have added this also
http://www.schultze.nu/php/phpinfo.php

[Lightning]

For mysql you should not use the root account for any access other than direct mysql commands. You need to create a new user with privileges.Something like this from a mysql command prompt logging is as root.

Code: Select all

mysql; GRANT ALL PRIVILEGES ON *.* TO New-User_Name@"%" IDENTIFIED BY 'passwordyouchoose' WITH GRANT OPTION;

Also if you have not set the root password you should using this command

Code: Select all

mysql: SET PASSWORD FOR root=PASSWORD('newpassword');

Make certain that every character is typed in.

After you have created the new-User_Name you can use that user name to login remotely. The root user can only be used directly from the mysql command prompt.

Also it would be helpful to let us know exactly what you are trying to accomplish and why?
A lot of the time there is easier or better ways of doing things.

[dingetje]

The mysql client library in the FREESCO Apache package is for MySQL 3.x and authentication may not be compatible with a MySQL 5.x database.
http://dev.mysql.com/doc/refman/4.1/en/old-client.html explains what can be done.

Code: Select all

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

replace 'some_host', 'some_user' and 'newpwd' with the required values for your situation. Also make sure you've granted privileges to this user as described in the reply from Lightning.