optimism_
05-15-2003, 02:37 PM
hi
i am trying to set up mysql remotely for a friend who doesnt know how to use it. I am trying to set up access permissions for everyone.
SELECT user,password,host FROM User;
returns 3 users now,
User Password Host
root pw here localhost
optimism_ pw here %
phpbb pw here 127.0.0.1
as i am using dialup, i must have % cos i have a dynamic ip. however, the problem is that i can log in as root user without supplying a password. This obviously is a big problem, but i dont see why when all accounts have passwords, and root is set up only to allow from localhost. Please help!
optimism_
i am trying to set up mysql remotely for a friend who doesnt know how to use it. I am trying to set up access permissions for everyone.
SELECT user,password,host FROM User;
returns 3 users now,
User Password Host
root pw here localhost
optimism_ pw here %
phpbb pw here 127.0.0.1
as i am using dialup, i must have % cos i have a dynamic ip. however, the problem is that i can log in as root user without supplying a password. This obviously is a big problem, but i dont see why when all accounts have passwords, and root is set up only to allow from localhost. Please help!
optimism_