Adding new User to mySQL?

[creole]

Hey folks...I am working with two sets of mySQL DB's. One local, one remote. How do I go about adding a user in the local version to reflect the remote?

Say username is andy, password is andy, and the access should be the same as root.

The reason why is because I want the same connect variables in both versions of my site.

[freddydoesphp]

First look at the records in the user table of the mysql db then insert a new record into that table with the same permissions as root had when you looked at it. Then type

mysql> FLUSH PRIVILEGES

[Ed Sullivan]

Run these 2 queries:
GRANT ALL ON *.* TO andy@localhost IDENTIFIED BY 'andy';
FLUSH PRIVILEGES;

Note that you might want to change "localhost" and you can use wild cards like those for a LIKE operator. You could even leave off the "@localhost" and it will be assumed to allow access from anywhere (andy@%)

[creole]

no such luck with either method.

This is the error that I get:

Warning: MySQL Connection Failed: Access denied for user: 'plusone@localhost' (Using password: YES) in ../fragments/main_header.php on line 170

Unable to connect to the database server at this time.

what now? It is no big deal, as I can just change the passwords in the include, but it would be much easier if I could simply use the same user/pass for both remote and local for this client.

[freddydoesphp]

Well it looks like you wanted to use the user name andy but in your code you have plusone Are you sure there is a record in the user table for plusone?

[creole]

sorry...that is the actual user I want to add. I went through and gave it full access like you said, Yes to everything, then I flushed the privileges and still no access. I even tried leaving out the "localhost" part and still nothing.

[freddydoesphp]

What does the Host field have for that user it should have 'localhost'

[creole]

right now it has % (using phpMyAdmin)

It HAD locahost. That was what I put in first. It was stil giving me the error so I tried leaving that off. It still gives me that error.

8(

[freddydoesphp]

Okay so back to your original problem of having two dbs using the same connect statement I will assume that you have one page which gets included in all your pages needing db access, so instead of wasting anymore time trying to get the username password deal to work why not just change the values in that one file or better yet make two copies of the file keep one on the rmeote server with the correct info and keep one on the lcoal side with root's settings and neevr touch them then your app should work wherever it is.

[creole]

I could do that but this is the way I have my setup.

I have a page (ill just use one for example) called welcome.php3. It contains my content. It includes a file called main_header.php. main_header is the file that contains my variables. It also contains navigation menus for the site which may change over time. SO, It would be safer for me to have the same user/pass that way I don't forget one of these times and upload a changed version with local user/pass and my site goes down.

You see? For the time being I will just do it the way you suggested, as I don't change the menu more than once a every month or two.

[freddydoesphp]

Or to save yourself a lot of time in the future just take the db connect vars out of main_header and put them into a file called let's say connect.php then add the include("connect.php"); to every page of the site above the include("main_header.php"); line. That way you are keeping the menu stuff separate from the db stuff.

[creole]

hehe

I was trying to avoid doing that. I spent about two hours getting rid of extra stuff from those pages to begin with.

But I suppose that is the best way to do it.

thanks for confirming

[freddydoesphp]

Do you use an html editor to do your coding most of them have search and replace so just search and replace

include("header.php");

with

include("connect.php");
include("header.php");