Accessing mysql database

[stuckinmobile]

I'm sure my problem is permissions related, yet I don't know what my next step should be.

After accessing mysql via: mysql -u root -p I was able to create a database.

When I try and access it via a php script, mysqli_connect_error() tells me: Access denied for user 'pi'@'localhost' (using password: YES)No database selected

In my php script there is: $con=mysqli_connect("localhost","pi","*******","db_name");

mysql_select_db("db_name");

I've double checked, all that content is correct.

While logged in to the database as root (via mysql -u root -p) I am able to access the database, create a table, insert content into it and read it back via "SELECT * FROM created_table".

FWIW, when I access mysql with a simple "mysql" at the command line, I do get the "mysql>" prompt. But SHOW DATABASES; does not list the "db_name" I created with root and it does not allow me to create a database.

Am I wrong to be able to expect to access a database created while root from a php script on a web page? How should I be approaching this??

Thanks from a Noobie.

[DougieLawson]

http://dev.mysql.com/doc/refman/5.1/en/ ... users.html

[rpdom]

You need to add permissions for the user "pi" to access the database "db_name" at "localhost". It depends on what permissions you want the "pi" user to have.

You then add these permissions to the main mysql database as root, using the "GRANT" command.

The least secure, lazy, option, is to do something like this

Code: Select all

pi@raspberrypi:~$ sudo mysql
(blah)
mysql> use mysql
(blah)
Database changed
mysql> GRANT ALL ON db_name.* TO `pi`@`localhost`;
OK
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)

mysql> quit

Please check out the syntax of the GRANT command before following this advice. I haven't checked it, just typed out as I remember it!

[stuckinmobile]

Thank you for the responses, will be trying them out tonight. (Day job is calling!)