MySQL/php assistance required...Please!

peevee

I am using a WAMP installation, with phpdev, I have not set any MySQL username and MySQL password while installing. However I created a file with the following code:

<?
$user="ramsys";
$password="ramsys";
$database="clients";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>

However when I run into at http://localhost/demo/ I get the following error.

Warning: Access denied for user: 'ramsys@127.0.0.1' (Using password: YES) in c:\phpdev\www\demo\index.php on line 5

Warning: MySQL Connection Failed: Access denied for user: 'ramsys@127.0.0.1' (Using password: YES) in c:\phpdev\www\demo\index.php on line 5
Unable to select database

Kindly advise how I can set the username and password for MySQL in a phpdev installation. However I am able to create tables using http://localhost/phpmyadmin/

Thanks for your time in advance....

bubblenut

According to the phpdev site it comes with phpmyadmin. Can you get into phpmyadmin?
If you gave no password at creation (which is often the case, it's easier to sort it out after the install) you'll be using root as the username and no password (an empty password).

devinemke

you need to setup a username and password in the database called "mysql" and the table called "user".

peevee

Thanks bubblenut and devinemke

I changed the code in the file as advised to as below and it works fine..

<?
$user="root";
$password="";
$database="clients";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>

Look forward to your continued support and guidance.

bubblenut

Bad idea, don't use root for all your db access. Set up different users with only the permissions which they require.

peevee

I could'nt agree more, no sooner had I added a couple of lines of codes to my script the following error came when I started phpmyadmin

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#2003 - Can't connect to MySQL server on 'localhost' (10061)

I guess the only reason could be that I had set the user to root, could you please advise on what steps I should take to rectify the above and
How can I assign a Set up different users with password and permissions in phpmyadmin. Where should I look for "Control Center".

Thanks in advance for your continued assistance.

devinemke

re-read my earlier post in this thread

peevee

Thanks,
As advised I have configured the databases with privileges. I also decided to scan through the MySQL tutorial, the manual and the phpMyAdmin documentation to understand the concepts better. I look forward to your continued support and guidance in understanding the same.