Databases
StackOverflow2013
Postsdbo
POAccess denied error when using mysql_real_escape_string()
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAccess denied error when using mysql_real_escape_string()
    primarykey
    data
    text
    <p>i am trying escape some data before it goes into my database, but i keep getting this error:</p> <pre><code>Warning: mysql_real_escape_string(): Access denied for user </code></pre> <p>Now this would usually suggest that i have not connected to the database (it also states (using password: NO)). </p> <p>I was a little confused by this because when connecting to a database i have a 'die' clause so if it fails to connect i get told about it. So i tested this theory by running a simple query in the same function that im trying to escape the data and it works just fine.</p> <p>So why on earth won't the escape method work or get a connection to the database. I did notice that the user the error states is not the user i use to access the database its something like 'www-data@localhost'. Could it be trying to log in with a different user, if so why and how? Because i another area of my website the escape function works just fine and i didn't do anything special to make it work, just added the code into my web page.</p> <p>thanks for the help. </p> <p>Are there any other ways of sanitizing my code?</p> <p>Okay, so here we go, when the user submits the form, i use AJAX to collect the data and put it into an obj to post(JSON encoding) it to the first PHP script which is here:</p> <p><a href="http://codepad.org/kGPljN4I" rel="nofollow">http://codepad.org/kGPljN4I</a></p> <p>This script checks all the data is there and then calls a function to add it to the database</p> <p>this Mysql class is called to escape the data and then add a new record to the database, when and instance of the class is made it makes a connection to the database:</p> <p><a href="http://codepad.org/wwGNrTJm" rel="nofollow">http://codepad.org/wwGNrTJm</a></p> <p>The third file is for constants, it holds the information for the database like pass, user and so on:</p> <p><a href="http://codepad.org/dl0QQbi9" rel="nofollow">http://codepad.org/dl0QQbi9</a></p> <p>any better?</p> <p>thanks again for the help.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USragebunny
    1. USragebunny
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. USMTVS
      1. VTFavorite
    1. COIt seems you're trying to call the funciton before you open a connection. Maybe in the other area of your website where this works, you already have the connection open..?
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. USbububaba
    2. CO@bububaba Well i tested that, i commented the code for escaping the data and put the code to run a simple SELECT query that returned data just fine so i am connected to the database. Thats what is so weird about it.
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. USragebunny
    3. COCheck for mysql_connect() in your script with the username given in the error. Most probably, you have given wrong credentials at the beginning somewhere.
      singulars
      1. POAccess denied error when using mysql_real_escape_string()
      1. USitachi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload