LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   MySQL root pass (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-root-pass-141326/)

tommytomato 02-02-2004 06:34 AM

MySQL root pass
 
Hi

I follow alot of instuctions on how to do this but some thing weid is happing.

I make sure MySQL is running
Quote:

[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
on test.*
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

TT
:study:


All times are GMT -5. The time now is 02:45 AM.