Continuing the previous tutorial on how to use MySQL in xampp, this time I will teach you how to view the SQL (Structured Query Language) from the MySQL database that has been created through the phpMyAdmin. Maybe there who think SQL is only shown when you first create a database, but it is not true because all the commands that we write when creating a database in phpMyAdmin are recorded by the system. Just as when we make the database through MySQL, all commands that we write is still displayed on the screen ,
Actually making the MySQL database through MySQL phpMyAdmin directly nor through the same thing, only if we make it in phpMyAdmin will be easier because all data is created, we can see just by clicking on a database or entity we want to see. Whereas if we use MySQL, the data was we created or we create will not be shown if we do not give the order to display them. But do not confuse them with the case, because the database that we created through phpMyAdmin or MySQL can be opened or viewed by both. If you do not believe try saja..hehe
Ehm..sepertinya me too much to say this, okay I just love how I look from the SQL database that has been created in phpMyAdmin. Follow the steps below ya ..
1. Open a web browser (eg mozilla) and then open phpMyAdmin (type localhost / phpmyadmin in the address bar).
2. Create databsenya in advance, for example, we created a database company.
3. The first time we make will have a SQL database that appears at the top of the screen, so this is one way to see SQLnya, but unfortunately the code will only be displayed when it was first set up and could still change as we edit / modify the database, to find out how see MySQL code so that it immediately follows the next step, yes ..
4. Once the database is complete, usually there is a mistake or if you wish to edit, so when the first database to fix it properly.
5. When a database is created already feels right then SQLnya was also ready to be viewed.
1. Open a web browser (eg mozilla) and then open phpMyAdmin (type localhost / phpmyadmin in the address bar).
2. Create databsenya in advance, for example, we created a database company.
3. The first time we make will have a SQL database that appears at the top of the screen, so this is one way to see SQLnya, but unfortunately the code will only be displayed when it was first set up and could still change as we edit / modify the database, to find out how see MySQL code so that it immediately follows the next step, yes ..
4. Once the database is complete, usually there is a mistake or if you wish to edit, so when the first database to fix it properly.
5. When a database is created already feels right then SQLnya was also ready to be viewed.
6. To see it, click the database you want to view and then select the menu export SQLnya
7. Then select the SQL and click go
8. The MySQL code is displayed as shown below:
9. But if you want to save the MySQL code, before the vote go, put a mark on the save as file and then select go
10. To open an SQL file that had been saved, open the file SQLnya earlier with editor Notepad ++ or easyphp or any other editor can (but now I use Notepad ++) by right-clicking on the file SQLnya were then select Edit with Notepad ++, it would appear look like this:
This SQL desired ..
I create / add MySQL database in cPanel
Demo This tutorial assumes you are logged into cPanel.
Now let's learn how to create a MySQL database in cPanel
1) Click the MySQL Database Wizard
2) Enter the name for the new database
3) Click Next Step
4) Now we will create a user to access the database ... enter your user name (username) here
5) Enter the password for that user and then again in the field below
6) If so, click Create User
7) Check here All Privileges to define the rights of the user ...
8) ... and then click Next Step
Done! The new MySQL database has been created, and the user database has also been added to the database in question. Database name, username and password will be needed by scripts that require a database connection
This is the end of this tutorial demo. Now that you understand how to create a MySQL database in cPanel.
// ON-Sunday, September 6, 2015
HOW TO CHANGE (ADDS) privilages
hello all my friend happy, not tired - tired man who Dwiki Hardy greet the faithful who come to this blog.
according to whom the promise before, now I will share about how to add user privileges in phpMyAdmin, so that we can create a database, delete, or modify an existing database from another computer, without the server computer.
Pastika agan can xampp of accessing other computers (not from a computer server). If not, read this tutorial here: http://itdwiki.blogspot.co.id/
okay assume that agan can mengkasesnya, then agan agan open a web browser and then ketiikan, "Emmanuel-ip address / phpmyadmin", and if it is successful then it looks like this:
according to whom the promise before, now I will share about how to add user privileges in phpMyAdmin, so that we can create a database, delete, or modify an existing database from another computer, without the server computer.
Pastika agan can xampp of accessing other computers (not from a computer server). If not, read this tutorial here: http://itdwiki.blogspot.co.id/
okay assume that agan can mengkasesnya, then agan agan open a web browser and then ketiikan, "Emmanuel-ip address / phpmyadmin", and if it is successful then it looks like this:
I add privileges, just click the tab privileges, and click the "add new user", as follows:
it will look like this:
fill it with filling login information:
- username: username contents agan, when agan want to access the database (eg, root)
- host: browse the pc name or IP address of the computer agan.
- password: fill in as Emmanuel, or if you want a more secure password agan can use options to generate passwords.
after all filled in, click the "Check All" to give them full access to the computers we have added above.
dech okay bro, so first of which, we continue another time.
okay. , ??
0 komentar:
Posting Komentar