We have already created our first database.īut before moving on, let's check what happened on the "physical" level of our hard drive by creating this new base. Surely, we will agree that it has been very easy. If we had to create a base for a Korean customer, Japanese, Arabic, Chinese, ect we must choose the corresponding character set:įinally, click on the Create button and then the name of the newly created database will appear in the column on the left, below the selection world that shows all the databases that we have on our server, as well as the name of the active database in the top path (breadcrumb or bread crumbs) that always indicates where we are standing: Let's do, step by step, what this example shows: within the text field we write courses (in lowercase letters), that will be the name of our new database.Īfter writing the name, we choose the character set that we will store (for texts in Spanish it will be utf8_spanish_ci, which corresponds to traditional Spanish, and allows us to use the ñ and the ch and ll). To create a new database, within the phpMyAdmin we will write (in the zone that is highlighted below) the name that we want to give (we will name it "courses"): Instead, locally (in our test server) we can create a new database for each project we are working on. With the phpMyAdmin open, the first thing we are going to do now is create a new database (many hostings already have one pre-installed, so in those hostings we will skip this step, and directly use the base that already exists). Bear in mind that if we do not use the base for more than 1440 seconds (24 minutes) it will ask us to enter our username and password again for MySQL. Once identified, we will be allowed access to the phpMyAdmin. In case you have used the XAMPP, EASYPHP or APPSERV the URL that we write will be:ĭepending on the emulator, it will ask us to identify ourselves with a MySQL user and password, in some cases the user is usually "root" and the password is empty, in other cases the user and password are declared during the installation. In order to create our first database, we can interact with phpMyAdmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |