Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Solved
Access denied for user: '@localhost' to database 'myblog'
Posted on 2004-10-06
I am having a problem trying to connect with MySQL with PHP. I get this error. Access denied for user: '@localhost' to database 'myblog'
This is my code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
<?
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if ($dbc = mysql_connect('127.0.0.1',
print '<P>Successfuly connected to MySQL.</P>';
mysql_close();
} else {
print '<p>Could not connect to MySQL.</p>';
}
if (@mysql_query ('CREATE DATABASE myblog')) {
print '<P>The Database has been created!</P>';
} else {
die ('<p>Could not create the database because: <b>' . mysql_error() . '</b></p>');
}
?>
</body>
</html>
END CODE
And as you can see in this screen shot: http://fizzmahon.2mydns.com/error.jpg
i have all the privaledges....
after running my code in a browser i get this...
-------
Successfuly connected to MySQL.
Could not create the database because: Access denied for user: '@localhost' to database 'myblog'
-------
and you can see it for yourself here: http://fizzmahon.2mydns.com/Temp/mysql.php
THANKS IN ADVANCED!!! IF YOU NEED ANY MORE INFO I CAN TELL YOU =D
FiZZ
This is my code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>
<?
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if ($dbc = mysql_connect('127.0.0.1',
print '<P>Successfuly connected to MySQL.</P>';
mysql_close();
} else {
print '<p>Could not connect to MySQL.</p>';
}
if (@mysql_query ('CREATE DATABASE myblog')) {
print '<P>The Database has been created!</P>';
} else {
die ('<p>Could not create the database because: <b>' . mysql_error() . '</b></p>');
}
?>
</body>
</html>
END CODE
And as you can see in this screen shot: http://fizzmahon.2mydns.com/error.jpg
i have all the privaledges....
after running my code in a browser i get this...
-------
Successfuly connected to MySQL.
Could not create the database because: Access denied for user: '@localhost' to database 'myblog'
-------
and you can see it for yourself here: http://fizzmahon.2mydns.com/Temp/mysql.php
THANKS IN ADVANCED!!! IF YOU NEED ANY MORE INFO I CAN TELL YOU =D
FiZZ
-
4
-
4
9 Comments
Possibly you have to use mysql_connect('localhost',
Regards
-r-
Regards
-r-
<?
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if ($dbc = mysql_connect('127.0.0.1',
print '<P>Successfuly connected to MySQL.</P>';
mysql_close();
} else {
print '<p>Could not connect to MySQL.</p>';
}
mysql_query ("CREATE DATABASE myblog") or die (mysql_error());
?>
Can you post the error if you use this code... thanks
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if ($dbc = mysql_connect('127.0.0.1',
print '<P>Successfuly connected to MySQL.</P>';
mysql_close();
} else {
print '<p>Could not connect to MySQL.</p>';
}
mysql_query ("CREATE DATABASE myblog") or die (mysql_error());
?>
Can you post the error if you use this code... thanks
Is it working now? I just check your link http://fizzmahon.2mydns.com/Temp/mysql.php
and got this as the result, the DB has been created....
**************************
Successfuly connected to MySQL.
Could not create the database because: Can't create database 'myblog'. Database exists
and got this as the result, the DB has been created....
**************************
Successfuly connected to MySQL.
Could not create the database because: Can't create database 'myblog'. Database exists
Yes it is working now... but i didnt change anything?!?!?! all i did was install phpmyadmin...
anyways i will grant you points...
anyways i will grant you points...
Featured Post
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Introduction
This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html). It addresses one of the most common problems that plague beginning PHP develop…
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month4 days, 7 hours left to enroll
589 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.