LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 02-02-2004, 07:34 AM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Rep: Reputation: 32
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

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


Reply


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 05:50 AM
Can't get pass this mysql syntax error Neruocomp Programming 5 07-24-2005 06:25 PM
Lost root pass word luckyvietman Linux - Newbie 11 06-01-2005 10:13 AM
How to pass mysql query to a variable? chynna_v Programming 4 09-03-2004 06:09 AM
Forgot MYSQL root pass jon_k Linux - Software 2 07-25-2003 02:03 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:27 PM.

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