Databases offer a method for managing large amounts of information easily over the web. They are necessary to run many web-based applications such as bulletin boards, content management systems, and online retail shops.
After creating the database, a user will need to be created and their privileges added to the newly created database. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.
To create a new user account:
Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.
To define a user’s privileges:
After doing all these steps, create the database's tables either via phpMyAdmin, MySQL software or use an online PHP or Perl script.
Note: The password remains the same format.
The connection string can be either of any examples below:
$dbh = DBI->connect("DBI:mysql:username_db01:localhost","username_admin","password");
$dbh=mysql_connect ("localhost", "username_admin", "password") or die ('I cannot connect to the database.'); mysql_select_db ("username_db01");
For more information on how to work with phpMyAdmin. please visit: phpMyAdmin.net.