Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 02-02-2004, 06:34 AM   #1
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 14.0.4 - Server Ubuntu 14.04.5 LTS
Posts: 946

Rep: Reputation: 32
MySQL root pass


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
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


Last edited by tommytomato; 02-02-2004 at 06:41 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ubuntu doesn't ask for root pass during install?? Ay-Karamba! Ubuntu 1 09-02-2005 04:50 AM
Can't get pass this mysql syntax error Neruocomp Programming 5 07-24-2005 05:25 PM
Lost root pass word luckyvietman Linux - Newbie 11 06-01-2005 09:13 AM
How to pass mysql query to a variable? chynna_v Programming 4 09-03-2004 05:09 AM
Forgot MYSQL root pass jon_k Linux - Software 2 07-25-2003 01:03 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:21 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration