[moron]

PREFACE:

My name is Al and I'm a moron who locked himself out of MySql. Alright, Let's rock.

I don't exactly remember changing my password, but since I was in the Terminal using commands like -u password, I think I might have done it on accident.

So... I need to change it back. And I don't want a work-around because I'm frustrated and confused and I want I back to normal, which I must confess: Was anything but normal when it was normal.

WHY I'M A MORON:

Two weeks ago, I couldn't have told you where my bin folder was located... Now I can tell you where 5 of them are. As well as 3 mysql, 2 apache & 8 php folders. So when you say "Hey, put the file in the php and connect it to the thing" please tell me which folder, so I don't crack my head on the screen again.

Lost In translation: I understand YourPasswordHere. I'm not an idiot, I'm a moron. When you start adding quotations and parenthesis around it, I'll assume that I'm supposed to add those. I understand alot better when thing are highlighted in bold.


DETAILS:
Macintosh G5 running OS 10.4.5
My "former" MySql password is root and I want it back.
My apple username and password: albert/apple
I have 3 versions of mysql installed and they are:

mysql-standard-5.0.19-osx10.4-powerpc
mysql-standard-5.0.19-osx10.4-powerpc-64bit
mysql-standard-4.1.18-apple-darwin8.2.0-powerpc
PHP version 4
PHP version 5


TROUBLE SHOOTING:
Every single thing in the world I have tried has resulted in the same two errors:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)



BEEN THERE DONE THAT:
People kept telling me to downloaded this Mamp thing and that it would somehow solve all of my php/mysql problems. Well, it did for about a week until this whole password thing went down. I first noticed there was a problem when I tried to start Mamp the other day and got the red MySql light and the green Apache light. When I tried to open the Mamp start page it says: Error: Could not connect to MySQL server!

So I tried to reset my password:
/Applications/MAMP/bin/mysql4/bin/mysqladmin -u root -p password

Grant privileges:
mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

following the MySql instructions:
mac:~ albert$ mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');

And got me this:
-bash: syntax error near unexpected token `('
mac:~ albert$ **** u
-bash: ****: command not found

And every other command in the book.
And people keep telling me to type commands, but they're not telling me what to type when it asks me for my password. The typical forum guy comes along and is like "Hey buddy, type this in the Terminal" and when I come back to tell him it asked me for my password, he's gone with the wind.


So, in attempt to restore my username and password I decided to uninstall everything:
1) I tried to uninstall Mamp by deleting the Mamp folder.
2) I tried to uninstall all 3 accounts of MySql by deleting the folders from /usr folder and deleted the preference pane.

And with my capacity, I think that's the way to go... Only problem is, it didn't reinstall the root user.

I even checked the the "official" MySql manual. With over 5,000 pages, they should consider renaming it to the MySql Labyrinth.

[UnrealEd]

hi,
it seems like you're really frustated with it, but i'll see what i can do

first: why did you install multiple versions of mysql and php on your computer? as they are all upgrades of the previous version, you only have to install the newest one.

second: is there somethin like an installed software list on the mac os (i'm working with windows so please forgive me if there isn't one)?
three: if so, can you uninstall software through that application?
four: remove ALL installed php and mysql versions.
five: reinstall the latest versions of both application (PHP 5.1.1 and mysql 5.0). All your existing databases will remain on your computer

post the problems here

Greetz,
UnrealEd

[hgarcia101685]

I remember when I set up my password the first time it was in a configuration file. I don't remember what it's called. But there's a field that says 'password' and 'user' or something like that. You open it up in a text editor, change it, save it again and MYSQL reads it and set it up for you.

Oh Also i just downloaded this thing called Xamp. It's tight....it does it all for you. You might want to check it out. I had problems setting up MySql too and I just gave up and started using xamp LOL.

[lindasnephew]

there isn't anything on mac like add/remove programs from windows where it lists all you installed programs and gives you an uninstall button..

it works kinda different on mac, you have an application and it just that one thing, you have an option to show contents which sort of opens it as a folder and in there is all the files that build up the app.

So most simple apps are just that and all you do to install it is drag it to the applications folder (or any folder for that matter) and it's done.

Some of the more complex programs (i.e. ms office for mac) have an install program which copies that one file mentioned above aswell as various files to hd/library and hd/users/username/library.

The simple style app is easily deleted by just trashing it. the more complex type you have to open the install app and there is normally and uninstall option in there.

Now something like sql, depending on exactly what you installed is like to be the complex kind as it has to open ports, start at login etc etc what ever it needs to do which makes me think that by just trashing you may slightly wrecked that (but i'm not positive)

what exactly have you installed to get php/apache/mysql.. are you using the built in function in tiger?

p.s once this is sorted i would recommend getting MAMP again, i've been using it a little while now and its stupidly simple, no config, it's stable and you just run it when you want by launching the app.

[Nico]

This thread is 2 years old, and the OP hasn't been active after posting this. I doubt he still needs help with that.