The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.
See if your editor made the list.
Course Of The Month
9 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Things That Drive Us Nuts
Have you noticed the use of the reCaptcha feature at EE and other web sites? Â It wants you to read and retype something that looks like this.
Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it i…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 3 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.