Access denied for user to database

I have built an SQL query and sent it to the MySQL Server using a PHP program/script. Everything was working fine and the connection was good until I attempted to CREATE DATABASE. Then I got this error:

Error: Access denied for user ''@'localhost' to database 'petcatalog'

Does anyone know why I am not connecting and how I fix this?

Thanks

P.S.
I know I can use the command prompt to build a database but I would like to complete this project of building a database using php scripts to connect with mysql server.

Apr 6 '10 #1

Subscribe Post Reply

4259

Markus

6,050

Expert 4TB

What is the full error message? It'll include something like 'USING PASSWORD yes'.

Apr 6 '10 #2

Dormilich

8,658

Expert Mod 8TB

it also looks like there’s no login name passed.

Apr 6 '10 #3

Atli

5,058

Expert 4TB

Note that you need to have the CREATE privilege for the database before you create it. Meaning that, before you create the database, a user with the GRANT privilege (like root) needs to issue a GRANT command, giving the user you are using in your scripts permission to create the database.

Because of this, you are generally just better of creating the database using the admin user. You are going to have to use it to grant the privileges anyways.

Apr 6 '10 #4

Markus

6,050

Expert 4TB

@Dormilich
I read it as "'user'@'localhost'" - woops :P

Apr 6 '10 #5

sIncognito

FULL ERROR MESS.

Database Selected:
Query: CREATE DATABASE Pet_Catalog
Results
Error: Access denied for user ''@'localhost' to database 'pet_catalog'

Apr 7 '10 #6

sIncognito

i am using the admin (root) account.

Apr 7 '10 #7

Markus

6,050

Expert 4TB

Can we see the code-in-question, please?

Apr 7 '10 #8

sIncognito

Expand|Select|Wrap|Line Numbers

 <?php

/*Program:    mysql_send.php

 *Desc:    PHP program that sends an SQL query to the

 *        MySQL server and displays the results.

 */

echo "<html>

    <head><title>SQL Query Sender</title></head>

    <body>";

if(ini_get("magic_quotes_gpc") == "1")

{

   $_POST['query'] = stripslashes($_POST['query']);

}

$host="localhost";

$user=" root";

$password=" *******";
 
/* Section that executes query and displays the results */

if(!empty($_POST['form']))

{

  $cxn = mysqli_connect($localhost,$root,$******,

                $_POST['database']);

  $result = mysqli_query($cxn,$_POST['query']);

  echo "Database Selected: <b>{$_POST['database']}</b><br>

      Query: <b>{$_POST['query']}</b>

      <h3>Results</h3><hr>";

  if($result == false)

  {

     echo "<h4>Error: ".mysqli_error($cxn)."</h4>";

  }

  elseif(@mysqli_num_rows($result) == 0)

  {

     echo "<h4>Query completed.

        No results returned.</h4>";

  }

  else

  {

   /* Display results */

    echo "<table border='1'><thead><tr>";

    $finfo = mysqli_fetch_fields($result);

    foreach($finfo as $field)

    {

       echo "<th>".$field->name."</th>";

      }

    echo "</tr></thead>

        <tbody>";

    for ($i=0;$i < mysqli_num_rows($result);$i++)

    {

       echo "<tr>";

       $row = mysqli_fetch_row($result);

       foreach($row as $value)

       {

          echo "<td>".$value."</td>";

       }

       echo "</tr>";

    }

    echo "</tbody></table>";

  }

 /* Display form  with only buttons after results */

  $query = str_replace("'","%&%",$_POST['query']);

  echo "<hr><br>

    <form action='{$_SERVER['PHP_SELF']}' method='POST'>

    <input type='hidden' name='query' value='$query'>

    <input type='hidden' name='database'

         value={$_POST['database']}>

    <input type='submit' name='queryButton'

         value='New Query'>

    <input type='submit' name='queryButton'

         value='Edit Query'>

    </form>";

  exit();

}
 
/* Displays form for query input */

if (@$_POST['queryButton'] != "Edit Query")

{

   $query = " ";

}

else

{

   $query = str_replace("%&%","'",$_POST['query']);

}

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>"

    method="POST">

<table>

 <tr><td style='text-align: right; font-weight: bold'>

       Type in database name</td>

    <td><input type="text" name="database"

         value=<?php echo @$_POST['database'] ?> ></td>

 </tr>

 <tr><td style='text-align: right; font-weight: bold'

        valign="top">Type in SQL query</td>

     <td><textarea name="query" cols="60"

        rows="10"><?php echo $query ?></textarea></td>

 </tr>

 <tr><td colspan="2" style='text-align: center'>

       <input type="submit" value="Submit Query"></td>

 </tr>

</table>

<input type="hidden" name="form" value="yes">

</form>

</body></html>

Apr 7 '10 #9

Markus

6,050

Expert 4TB

You do not have the variable $root defined (line #20); I believe you mean to use the variable $user (line #14). You should remove that leading space from your $user variable, too.

Apr 7 '10 #10

sIncognito

I should mention that I am very new at this.

what do you mean by the variable $root not being defined, and
using the variable $user?

I am learning as I go...

Apr 7 '10 #11

Dormilich

8,658

Expert Mod 8TB

Expand|Select|Wrap|Line Numbers

 $host="localhost";
 $user=" root";

$password=" *******";
 
if(!empty($_POST['form']))

{

  $cxn = mysqli_connect($localhost,$root,$******,

Apr 7 '10 #12

sIncognito

so how do I define this to allow access to the localhost?

Apr 8 '10 #13

Dormilich

8,658

Expert Mod 8TB

I’d go for

Expand|Select|Wrap|Line Numbers

 $host="localhost";

$user="root";

$password=" *******";
 
if(!empty($_POST['form']))

{

  $cxn = mysqli_connect($localhost,$user,$******,

Apr 8 '10 #14

by: Randell D. | last post by:

Folks, I use PHP to write my form data to MySQL. I have a database with about ten tables. I'm trying to fill one table with some dummy data (its a contact manager table holding names of...

PHP

Access denied, simple task

by: Andreas Reuleaux | last post by:

What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), does not any more with mysql 3.23.56 of fink (current-stable, for fink cf. fink.sf.net) - I am not sure, if this problem is caused...

MySQL Database

Error 1044 Access denied to database

by: John | last post by:

Hello. I am currently working through a book on Dreamweaver and using PHP. I am having a little trouble with setting up the database though. I have php 4.2.3 and MySQL 4.0.20a. I am running...

MySQL Database

Problems with DTS package. Access denied

by: Jim Andersen | last post by:

Hi, I made a DTS-package and it works when I execute it manually, but when it is run by the SQL Server Agent, it fails. I have use the guide to create a maintenance plan. That doesn't work so...

Microsoft SQL Server

access denied using a dll that calls a com object

by: vincentw56 | last post by:

This is the first time I have tried this. What we have is a com object the generates keys. A developer here wrote a .Net wrapper in C# for this com object. I am trying to call her dll wrapper...

ASP / Active Server Pages

Type.GetType Access is denied

by: RichB | last post by:

Hello, The .NET application I have just installed at a client web site is throwing a strange error. At first the applications works without any problems, but after 10 mins or so Access denied...

C# / C Sharp

SQL Server does not exist or access denied

by: geodev | last post by:

I have developed a small application using ASP.NET and VB.NET on my development machine it works great. When I copy across the files manually to my test machine and create a Virtual Directory all...

ASP.NET

SQL server didn't exist or access denied

by: Johan Johansson (Sweden) | last post by:

I can't connect to our database (seperate database server) from within my webservice. I cannot understand why.!!! * I have configured IIS not to allow anonymous access and to use "windows...

.NET Framework

SQL Server does not exist or access denied.

by: sammyloo | last post by:

Hi all, I'm experiencing a problem using ASP.NET web services to access a different server with SQL Server 2000 database. And I get the error of the following Exception Details:...

ASP.NET

java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

by: ajos | last post by:

hi frnds, im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception. to verify this error ive...

MySQL Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Access denied for user to database

Similar topics