I follow alot of instuctions on how to do this but some thing weid is happing.
I make sure MySQL is running
[root@www root]# /etc/rc.d/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
then i change my root pass.
mysqladmin -u root password 'my_password'
then i create a new user after creating a database.
create database test;
add new user
grant select, insert, update, delete, create, drop
to my_user identified by 'my_new_pass';
when i connect to the database using a config file say like phpnuke
its using the 2nd pass but the user is root.
some how i do think thats right
O yer i forgot to say, when loging into MySQL its using the new password i created for the new user, not the first password i put in for MySQL
if that makes sence !
any one help me out please
OS white BOX