Installation of MySQL

zingbats

Sorry if this post is not really relevant, however, I shall talk and see what happens.

I downloaded the MySQL installer file (4.0) and installed it fine. The only problem being, I have NO idea what the root password is... Do you know how to find it? Or, what the default password is?

Or, indeed ANYTHING that will allow me to use PHPMYADMIN.

Regards;
Alex.

codeman

well, assuming you're logged into the computer you should be able to just execute the mysql binary (either from bash or dos) and it might let you in without any password (depending on wh o you log in as...)

mysql
(or ./mysql)

once you have logged in execute the grant command to specify a new user and the permissions that user has on the database... If you can't log in then get whoever knows the root password to log in and grant you permissions, then log in as that user to mysql next time.

by default there is no default password on a linux /gnu box, although if the sysadmin hates you try "admin" or "password" 🙂

zingbats

lol, cheers. It's a windows server (my own comp 😃)

I have NO idea how to login as I have no PASSWORD!! Which is why this a catch22... I cant change the password until I know the password!

I dont know WHERE to login to or anything..

Alex

zingbats

lol

I have just read
http://www.mysql.com/doc/en/Default_privileges.html

Which says alot, however, one bit says
"shell> mysql -u root mysql"

Windows HAS no shell

codeman

WELL, IF YOU ARE USING WINDOWS:

RUN E:\SITE\MYSQL\bin\winmysqladmin.exe THIS MIGHT BE DIFFERENT DEPENDING ON WHERE YOU INSTALLED MYSQL. LOG IN WITH YOUR WINDOWS USER NAME AND PASSWORD
JUST OPEN THE DOS PROMPT AND NAVIGATE TO THE BIN DIRECTORY... IN MY CASE IT WOULD BE E:\SITE\MYSQL\BIN. FROM THERE JUST TYPE IN mysql AND IT WILL START WITHOUT A PASSWORD.