How to create and use mysql database using php myadmin

How to create and use mysql database using phpmyadmin

Designing a database takes time and thought. So, I think it’s a good idea to work with a local installation of phpMyAdmin. Make sure everything works as intended, and then transfer the database to your remote server. So, let’s create a database to work with for the rest of this articles. We’ll, also discuss the meaning of collation, which controls the sort order. If you haven’t already done so, launch your local installation of phpMyAdmin. And login if necessary as the root super user.

In the general settings panel at the top center. Sever connection collation is set by default to UTF8 general CI.

This sets the default sort order of all the databases on this server to “ case insensitive(ci) “. And I recommend that you don’t change this value, unless you’ve got a very strong reason for doing so. So to create the database, click the Databases tab at the top left. And if you are logged in as the root user, you should be able to see this Create database field. Which is where you enter the name for the database.

PHPMyAdmin Create Database

If the name of the database on your remote server has already been decided, use that. If you’re free to choose the name of the database, choose something that describes the data you plan to store.

Standards To Create Database

Although phpMyAdmin allows you to use spaces and special characters in database names. It’s best to use only letters, numbers, and the underscore. In other words, no spaces. And to avoid problems with case sensitivity, it’s also a good idea to use all lower case.

I’m going to call the database for this article and rest of MySQL articles “ learnkoding ”. And I’m going to use underscores to join the words. So in that field, “ learn_koding “.

Collation in MySQL

Collation here sets the collation, or the sort order, for this individual database. If you’re using English, don’t change the default. But, if you’re storing data in another language, you need to choose the appropriate collation, from the drop down menu. And if you open this drop down menu, you’ll see there’s an absolutely enormous choice of collations. Most of the time, you’ll want to use utf8. And it’s right down towards the bottom. And you can see this czech_ci, danish_ci, estonian_ci, the ci at the end stands for case insensitive. This one at the top which has got bin at the end, stands for binary sort order. There are other sort orders which end in cs, and that is case sensitive.

If you don’t know which one to choose just go for the default collation. You can change the value of collation for individual tables and even columns at anytime later, after the database has been created.

Conclusion

Creating a database is simple. The database learn_koding has been created. Just give it a name, and set collation, if necessary. Normally, you should use the same name as the database on your remote server. If you can choose the name yourself, stick to lowercase letters, numbers, and the underscore. Don’t use spaces. Collation sets the default order. For English, leave collation at the default value.