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

Reply via email to