MySQL permissions !!!

bjoerndalen

HI guys ..

Just started playing with MySQL and was wondering if someone could help with a couple of questions I have.

When I run MySQl.exe from the bin folder, why is it that I dont get asked for a password etc.

I was of the opinion that you were asked for host, user and password parameters before being able to use MySQL.

I am using it on my own computer for learning.

Could someone also explain how the winmysqladmin works...

I apologise in advance for being a bit thick 😕

Cheers Dave

r270ba

Actually all the mysql.exe is doing is starting up the mysql server. MySQL can be accessed through dos but there are many GUI's out there that will do what you are takling about....double click and add host, user, and pass..

MySQL Control Center (www.mysql.com)
SQLyog (do a search on google)
-many more...just search for mySQL gui or mySQL front-end

Hope this helps!

By the way, once you have downloaded and installed this your host will be "localhost" (without the "").

DigitalExpl0it

File attached might help

bjoerndalen

Thanx for your comments guys.

I probably didnt explain myself too well...

I can get MySQL to work and have created a database and populated it with data. The SQL commands are working fine.

I'm afraid it's just me trying to work things out.

Its just that when I open MySQL I have never been asked for any passwords etc. I expected this to happen. If I have understood correctly , as it stands now if someone came to my computer and opened MySQL then they could do whatever to my database at will. I was just wondering how you can prevent this. I have accessed the mysql database and used the SELECT * FROM user query and I see there are two accounts. The root account which as no password and another one which as the parameters I set when I installed MySQL. Am I right in thinking that when I access MySQL I am using the root account and therefore , as no password is set , entry to MySQL is opened. If this is the case how can I prevent this or make it so that my other account is used....

I hope that makes sense...

I only started messing with it a couple of days ago so I'm just trying to get my head around it...

I downloaded the zip file. Thanx very much. I guess I can use this to add different accounts to MySQL with differing permissions. Is this right???

Look forward to your replies ..

Dave

🙂