Hi all....
I have a bit of a security problem with mysql. I'm working on a server where mysql was installed on the same machine as the actual web server. When I telnet into the server, log in with my uxix login and password and type mysql at the command line it bring me into the root. This is not a good thing.... so I tried to change the root user by doing this (form the mysql docs)
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
when I then select the passwords from the user table I see the update. However, where I log into mysql (or just simply type mysql at the command line) it still lets me in regardless..... I'm kinda stumped (confused) and have been all over the documents.... is there something really stupid that I'm missing here ......or is there another approach?
Thanks always in advance....
I have a bit of a security problem with mysql. I'm working on a server where mysql was installed on the same machine as the actual web server. When I telnet into the server, log in with my uxix login and password and type mysql at the command line it bring me into the root. This is not a good thing.... so I tried to change the root user by doing this (form the mysql docs)
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
when I then select the passwords from the user table I see the update. However, where I log into mysql (or just simply type mysql at the command line) it still lets me in regardless..... I'm kinda stumped (confused) and have been all over the documents.... is there something really stupid that I'm missing here ......or is there another approach?
Thanks always in advance....