I just installed apache 4.x on Kubuntu 5.10 via apt-get. I want to
securethe account as per the instructions found at:
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html
I apparantly have these users:
mysql> select Host, User FROM mysql.user;
+-----------+------------------+
| Host | User |
+-----------+------------------+
| ety | root |
| localhost | debian-sys-maint |
| localhost | root |
+-----------+------------------+
3 rows in set (0.11 sec)
So I proceed tto the first step in the guide, but I get this error:
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('my_password_here');
ERROR 1133: Can't find any matching row in the user table
What is the proper way to continue? Should I use these three commands?:
mysql> SET PASSWORD FOR 'root'@'ety' = PASSWORD('my_password_here');
mysql> SET PASSWORD FOR 'debian-sys-maint'@'localhost' =
PASSWORD('my_password_here');
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('my_password_here');
Thank you in advance.
Dotan Cohen
http://technology-sleuth.com/question/how_can_i_be_safe_online.html
|