passwds and permissions to the users table in mysql.<BR><BR>2. I need to add the possible host that can access this db. This will need to cover my work systems (i assume i can just do an IP mask ie.

Run the following query to retrieve the user and password columns: SELECT User, Host, authentication_string FROM mysql.user; ...

So let's take a quick look at the process involved in creating a new database and a new user account or two to manage it. If you're really a MySQL newbie, you might be wondering what the host ...

you can then connect to that database server with a graphical user interface tool such as Beekeeper Studio or Adminer. With Beekeeper studio, create a new connection, select MySQL as the ...