[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

error when attempting to connect to MySQL with PHP

Posted on 2007-11-13
6
Medium Priority
?
2,971 Views
Last Modified: 2013-12-13
I am using Windows Small Business Server 2003 with IIS 6.0.  I am attempting to connect to a mysql database using the following code:

$conn = mysqli_connect('192.168.1.x', 'root@localhost', 'password', 'database');

I have also created another user account, and provided all privileges to the account in the MySQL client.  I then tried connecting with the new user account with the same error message

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root@localhost'@'cogent-s1.CogentMedia.local' (using password: YES) in C:\StuffLocator\email_verification.php on line 20
Access denied for user 'root@localhost'@'cogent-s1.CogentMedia.local' (using password: YES)

I have checked the php.ini to ensure that the extension=php.mysqli.dll is uncommented and that the php.mysql.dll is in the extensions folder.

I appreciate all help that can be provided.  
0
Comment
Question by:GarrettChristopherson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
samalraj earned 2000 total points
ID: 20277831
Hi,
      can you try this

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'databaseName';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $conn);

just give tn user name as root no need the domain like root@localhost
0
 
LVL 5

Author Comment

by:GarrettChristopherson
ID: 20277885
I noticed that you are using mysql_connect instead of mysqli_connect (with the i after the mysql part).  My reading has taught me that mysql is for older versions of PHP and MySQL, and does not include all of the new functions and OOP properties of the mysqli package.  

I tried using variables instead of place just the values into the mysqli_connect method:

$localhost = 'localhost';
$username = 'root';
$password = 'password';
$database = 'db';
 $conn = mysqli_connect('$localhost', '$username', '$password', '$database');

and got this error:

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host '$localhost' (11004) in C:\StuffLocator\email_verification.php on line 24
Unknown MySQL server host '$localhost' (11004)

Is there something that I have to do in the MySQL client to get the localhost linked to the database?
0
 
LVL 5

Author Comment

by:GarrettChristopherson
ID: 20277937
t tried the following code:

$localhost = 'localhost';
$username = 'root';
$password = 'ljfs531ljfs531';
$database = 'test_001';
 $conn = mysql_connect('$localhost', '$username', '$password');
mysql_select_db($database, $conn);

and received the following errors:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host '$localhost' (11004) in C:\StuffLocator\email_verification.php on line 24

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\StuffLocator\email_verification.php on line 25

This was using the older mysql_connection. any ideas
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 3

Assisted Solution

by:samalraj
samalraj earned 2000 total points
ID: 20277994
Hi,
      when using variable you don't have to use single quote
instead of
 $conn = mysqli_connect('$localhost', '$username', '$password', '$database');
use
 $conn = mysqli_connect($localhost, $username, $password, $database);
0
 
LVL 5

Author Comment

by:GarrettChristopherson
ID: 20278033
Thanks, now I have other problems with other sections of the code, but at least I'm connecting now.  thanks for your help!
0
 
LVL 3

Expert Comment

by:samalraj
ID: 20278056
Welcome, I am happy to assist you.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
The viewer will learn how to count occurrences of each item in an array.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question