Description:
We are doing project in PHP4.3 and Mysql 4.1.11.
PHP 4.3 is properly working with Apace2.0 Server.
In Mysql we can create database, tables and all database operations.
The configuration of Mysql is,
Server Name=”root”
Prot=Default Port”localhost: 3306”
Password is ”server”
While connecting PHP4.3 and Mysql using the query
1.“mysql_connect('localhost:3306', 'root', 'server')” it will give error “Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client”.
2. mysql_connect('localhost', 'root@localhost', ‘server'); It will give error “Warning: mysql_connect(): Access denied for user 'root@localhost'@'localhost' (using password: YES) in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3
Could not connect: Access denied for user 'root@localhost'@'localhost' (using password: YES)
3. $link = mysql_connect('3306', 'root', 'server'). It will give error “Warning: mysql_connect(): Can't connect to MySQL server on '3306' (10060) in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3
Could not connect: Can't connect to MySQL server on '3306' (10060)”
These are the warning we are getting.
The sytax is mysql_connect(‘Host’, ‘username’, ’password’);
Give details about this, how the connection will establish, what are the arguments, etc…
Could you give some simple procedures for selecting, inserting, updating and deleting operations?
How to repeat:
While establishing any communication between PHP4.3 and Mysql4.1.11,
While accessing a Database or tables,etc...
Suggested fix:
What is the value in the field of user, in mysql_connect().
We never give a username while implementing mysql.
Give the sysntax and example for each one.
Like what is the Portno, server name and password.
Give a corresponding example to that.
Description: We are doing project in PHP4.3 and Mysql 4.1.11. PHP 4.3 is properly working with Apace2.0 Server. In Mysql we can create database, tables and all database operations. The configuration of Mysql is, Server Name=”root” Prot=Default Port”localhost: 3306” Password is ”server” While connecting PHP4.3 and Mysql using the query 1.“mysql_connect('localhost:3306', 'root', 'server')” it will give error “Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3 Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client”. 2. mysql_connect('localhost', 'root@localhost', ‘server'); It will give error “Warning: mysql_connect(): Access denied for user 'root@localhost'@'localhost' (using password: YES) in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3 Could not connect: Access denied for user 'root@localhost'@'localhost' (using password: YES) 3. $link = mysql_connect('3306', 'root', 'server'). It will give error “Warning: mysql_connect(): Can't connect to MySQL server on '3306' (10060) in D:\Program Files\Apache Group\Apache2\htdocs\select2.php on line 3 Could not connect: Can't connect to MySQL server on '3306' (10060)” These are the warning we are getting. The sytax is mysql_connect(‘Host’, ‘username’, ’password’); Give details about this, how the connection will establish, what are the arguments, etc… Could you give some simple procedures for selecting, inserting, updating and deleting operations? How to repeat: While establishing any communication between PHP4.3 and Mysql4.1.11, While accessing a Database or tables,etc... Suggested fix: What is the value in the field of user, in mysql_connect(). We never give a username while implementing mysql. Give the sysntax and example for each one. Like what is the Portno, server name and password. Give a corresponding example to that.