Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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
[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
-
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
Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This article discusses how to implement server side field validation and display customized error messages to the client.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses
Course of the Month8 days, 18 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.