I should clarify what I used as a command. I'm sure some would already assume
what happened, but just to eliminate all possibility of ambiguity, the command
I posted:
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
came from the following website:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
When I actually typed it into my command prompt, I tried it several ways. Here
are examples of how I tried it:
mysql>SET PASSWORD FOR ' '@'localhost' = Password('djnr84KF&%')
That is not really the password, but a mockup. (of course)
I also tried:
mysql>SET PASSWORD FOR 'root'@'localhost' = Password('djnr84KF&%')
and:
mysql>SET PASSWORD FOR 'paul'@'localhost' = Password('djnr84KF&%')
and:
mysql>SET PASSWORD FOR '127.0.0.1'@'localhost' = Password('djnr84KF&%')
I think I tried several other ways also, I just don't remember them all exactly.
Is there something I'm missing here?
Am I taking the example command too literally, or not enough?
Thanks
Paul
From: [email protected]
To: [email protected]
Date: Mon, 1 Sep 2008 12:58:26 -0700
Subject: [LinuxUsers] MySQL security
I installed MySQL on my Ubuntu desktop, (I'm still using Feisty, but I don't
think that should matter, it's updated) and I noticed that in the MySQL
documentation it said I need to set a password for the root admin account, and
an anonymous account, which both have root permissions. I used the commands
that they posted on the website to do just that, but MySQL doesn't seem to
recognize what I am doing. In other words, it won't let me log in. The port is
set to 3306(MySQL) by default, but it does not accept my log in, in MySQL
Aministration, (or mysql-admin) package.
My question is, as long as I kill all the MySQL PIDs, will I be secure, when
I'm online?
In other words, if the MySQL PIDs are killed, then isn't it true that no-one
can hack into mysql, because it's turned off?
Another question:
After I installed mysql, I noticed that evolution was running when I checked
htop. Is evolution a default install for ubuntu 7.04, or is it part of mysql?
Is there a way to configure ubuntu, or even linux, so that certain Processes
will not start on startup, so I don't have to kill them every time I start up,
but I don't want to uninstall them. So that I can turn them on later when I
want them?
Thanks
Paul
Talk to your Yahoo! Friends via Windows Live Messenger. Find Out How
_________________________________________________________________
Get ideas on sharing photos from people like you. Find new ways to share.
http://www.windowslive.com/explore/photogallery/posts?ocid=TXT_TAGLM_WL_Photo_Gallery_082008
