This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| commissies:gamescom:manual_phpmyadmin [2009/03/10 10:19] – willem | commissies:gamescom:manual_phpmyadmin [2009/03/10 11:41] (current) – willem | ||
|---|---|---|---|
| Line 24: | Line 24: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| - | {{ http:// | + | |
| Once on this page we will have to fill in several fields: (right screen). | Once on this page we will have to fill in several fields: (right screen). | ||
| + | {{ http:// | ||
| * **Username**: | * **Username**: | ||
| * **Host**: Since we are most likely only going to use this user on the same machine as the stats and mysql is hosted, lets just use '// | * **Host**: Since we are most likely only going to use this user on the same machine as the stats and mysql is hosted, lets just use '// | ||
| Line 33: | Line 34: | ||
| After hitting '// | After hitting '// | ||
| Congrats! You can now use this user! | Congrats! You can now use this user! | ||
| - | \\ | ||
| - | Used Pictures: \\ | ||
| - | [[http:// | ||
| - | |||
| ===== 2. Databases ===== | ===== 2. Databases ===== | ||
| - | This chapter will handle the creation of databases and ... | + | This chapter will explain certain options you can do with a database. \\ |
| + | In the example screenshots we will always use the username '// | ||
| ==== 2.1. Create ==== | ==== 2.1. Create ==== | ||
| - | N/A for now, will be filled later. | + | There are 2 ways of creating a database: \\ |
| + | \\ | ||
| + | **//1. With root//** \\ | ||
| + | Normally a user won't have any rights to create any database itself. In which case you will have to ask someone with root access to create you a database. \\ | ||
| + | This can also be done yourself, in which case you will have to create the database, edit the privileges of the user and add the user to the newly created database with rights. \\ | ||
| + | \\ | ||
| + | **//2. With a user itself//** \\ | ||
| + | If the person who gave you an account (or you have made it yourself) and that user has been created with the option '// | ||
| + | \\ | ||
| + | I will explain the second possibility, | ||
| + | \\ | ||
| + | {{http:// | ||
| + | First, again, lets go to the phpmyadmin page via a browser. Use your login and password and hit enter (I'm using the login: // | ||
| + | \\ | ||
| + | Next in line would be the creation of a database. The browser will already show you the text '// | ||
| + | \\ | ||
| + | \\ | ||
| + | \\ | ||
| + | Congrats, you have now created a database with the user '// | ||
| + | \\ | ||
| ==== 2.2. Adjust ==== | ==== 2.2. Adjust ==== | ||
| Line 48: | Line 65: | ||
| ==== 2.3. Import ==== | ==== 2.3. Import ==== | ||
| + | PhpMyAdmin gives you the possiblity to import sql files into already excisting databases. Again, in order to do this you should login as the user with the correct database privileges (for this manual that would '// | ||
| + | \\ | ||
| + | {{http:// | ||
| + | There are several ways of accessing a databse. In this manual I will just use a simple example and go from there. We will be using the database called '// | ||
| + | First it is important to select the database you want to update. This can be done by simply using your mouse to hover over the name, in phpmyadmin, on the left side of the screen and clicking on the database name (screen left). \\ | ||
| + | \\ | ||
| + | This will open a new screen, with the current database selected on the left side. On the right, click on the tab that is called '// | ||
| + | \\ | ||
| + | Congrats! You have just imported a sql file into the database '// | ||
| ===== 3. Other... ===== | ===== 3. Other... ===== | ||
| This chapter is just a placeholder and will be expanded / replaced over time. | This chapter is just a placeholder and will be expanded / replaced over time. | ||
| + | |||
| + | ====== Used pictures ====== | ||
| + | Used Pictures: \\ | ||
| + | Create user: [[http:// | ||
| + | Create database: [[http:// | ||
| + | Import database: [[http:// | ||