password for root

Hi, I installed mysql, and found root can login without a password. So I checked mysql manual and setup a password for root. However, according to the manual, I need to type another commond: "flush privileges;" I don't undersdant why should I do this. Any one can give me a hint? Alex ---

How to drop a user from mysql?

A newbie question: how to drop a user from mysql? Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[

new user privileges

Hi, I'm new in mysql admin. I have question on create new user. Suppose I have created a database called 'abcdb'. Now I want to add a new user with full privileges on only 'abcdb'. How should I do? I tried 'grant all privileges on abcdb.*' but still the new user has the superuser privileges.

Newbie need help on MySQL on RH 7.1

Hi, I installed a RH 7.1, and I installed all the packages for apache, php and mysql. I don't know how to check if mysql server is running. On my machine cannot connect to mysql server. Thanks in advance for all advices if can help me out! Regards, Alex shi