I have a mysql database (version 3.23.47) running on a virtual server. I have taken the running over from someone else and have been having trouble with database permissions. To combat this I bypassed passwords by creating a my.cnf file. I then have deleted all records in the mysql.user table and am starting afresh.
How is the best way to reconstruct this table? Can I add admin@localhost and say a webmaster with access from anywhere? I have looked everywhere for a security guide, can any one point me in the direction of good practice documents? I need to learn more about creating accounts for websites to query databases. many thanks, Gav. --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php