From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Setting up a user account

Setting up a user account

From the course: Learning phpMyAdmin

Start my 1-month free trial

Setting up a user account

“

- After creating a database in your local version of phpMyAdmin, it's a good idea to create one or more user accounts with the same user names and privileges as on your remote server. This allows you to test your application in a more realistic way than connecting to MySQL all the time as the root superuser with unlimited privileges. In phpMyAdmin make sure that you're in the Home page, then select the Users tab, it's the fourth from the left at the top. And users overview lists all the user accounts registered on the sever. The list of user accounts on your server will depend on how MySQL and phpMyAdmin were installed. This is an installation that was originally created using XAMPP on Windows, and it's got a lot of anonymous users, so I want to get rid of those anonymous users. So User name, Any, we'll select that check box. Again, Any, we'll select that check box. If you've got pma, you want to keep that, but here we've got two root users that don't have passwords, so we need to get…

Contents