Web Hosting Talk







View Full Version : Questons on MySQL


zbco
08-28-2001, 01:20 AM
Hi

I have installed the mysql patch from pkg.nl.cobalt.com and have changed the root password. What other else must I do? I read somewhere that I must get rid of the anonymous usernames that is there by default... how do I do it.... I can find the instructions again.

Thanks.

(SH)Saeed
08-28-2001, 04:31 AM
Download this phpMyAdmin, it's a tool that lets you manage your MySQL database. You can simply add and remove entries from your database.

http://www.phpwizard.net/projects/phpMyAdmin/

Enjoy.

zbco
08-28-2001, 04:55 AM
How do I get rid of default username?

I would like the commands that I can type in Telnet

madsere
08-28-2001, 08:16 AM
Originally posted by zbco
How do I get rid of default username?

I would like the commands that I can type in Telnet

I would delete the two no-password users mysql creates by default:

mysql -u root -p mysql
>delete from user where password = "";
>quit;

zbco
08-28-2001, 11:30 AM
Thanks.