You wrote, "You need to create a root password and other users."
insert into mysql.user set
Host='localhost',
User='<whatever userid you want>',
* * * * * * * * * *
Thanks, but that gave me an error message.
I clicked on a particular database, then clicked Privileges and changed the
password from "root" to "chestnut." But instead of assigning chestnut to that
database, it apparently assigned it to EVERY database.
Every database I click Privileges on now displays the following:
User
Host
Type
Privileges
Grant
Action
chestnut
localhost
global
ALL PRIVILEGES
Yes
root
localhost
global
ALL PRIVILEGES
Yes
root
webeditions-computer.local
global
ALL PRIVILEGES
Yes
Yet I can't write a database connection using "chestnut" as the
username....except for the table "test." This is what its privileges look like:
User
Host
Type
Privileges
Grant
Action
Any
%
database-specific
ALL PRIVILEGES
No
chestnut
localhost
global
ALL PRIVILEGES
Yes
root
localhost
global
ALL PRIVILEGES
Yes
root
webeditions-computer.local
global
ALL PRIVILEGES
Is there some way I can go into phpMyAdmin > NewDatabase > Privileges and
change User to "Any" and Host to "%"? I don't want to do it if it's going to
show up on every single database.
Thanks.
____________________________________________________________________________________
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
