Ticket Options

Question Details

TICKET ARCHIVE -> Mysql Password Problem

warmac - Sep 27, 2005 - 6:51 pm

for a long time, i have never been able to get this to work

mysqladmin -u root password:

i've mainly used root which doesn't require a password

it all started initiall when i was reading max osx web development book and prior to setting up password it had me do a .bashrc profile

as i followed instructions

echo 'export PATH=/usr/local/mysql/bin: $PATH' >> ~/.BASHRC

then to create bash_profile


i think the .bash may be not right since the error i get in terminal when trying to do the password is this

-bash: mysqladmin: command no found

i've always had .bash errors not sure why

is there any step by step guide i can follow to make it all work ?

or is there a way to use netinfo manager to set a password instead ?

thanks in advance

i'm on a powermac g4 panther 10.3.9

mkwan - Sep 27, 2005 - 9:55 pm

try this in the .bash_profile

export PATH=$PATH:/usr/local/mysql/bin

and restart terminal

mkwan

warmac - Sep 28, 2005 - 2:57 pm

when you say try this, do you mean open the file up itself and insert this or do it through terminal

i tried it like this in terminal

~user$ export PATH=$PATH:/usr/local/mysql/bin

then after enter it opens up a new line i restarted terminal now what ?

I tried the mysqladmin create password but same error results

I even successfully redid the export via the mac osx development book and according to the book the next step is mysqladmin -u password password but when i try it and hit enter it still results in command not found should i try to delete any existing password via the netinfo manager ? there shouldn't be any but just incase or is there any other way to get it working

warmac - Sep 28, 2005 - 3:02 pm

i checked netinfo manager and it shows the following

mysql user password *
root user password ********

should root have a password ? i thought it didn't need one, i've been using programs on my local host via root without entering any password

as for the mysqladmin -u root password password is this for the mysql user ? in which case can't i enter a new password via the netinfo manager ?

mkwan - Sep 28, 2005 - 3:38 pm

sorry, my mistake, try entering this command:

echo 'export PATH=$PATH:/usr/local/mysql/bin' >> ~/.bash_profile

the root password for mysql is completely different from the root password of the operating system. I don't believe you need fiddle with netinfo.

if that still doesn't work, my msn name is m_kwan@hotmail.com

FYI: this site below is for additional help for mac users:

http://www.macosx.com/apps/help.htm

what that does is let a volunteer tech like me to remotely connect to your computer and take a look of what's going on. You have complete control of tech's remote connection(your provocative to break the link, etc,...)

I hope what I said make sense...let me know if it doesn't

mkwan