How to use phpMyAdmin

( Case study )

By Sergey Skudaev

++++++

In this tutorial you will learn how to use phpMyAdmin to manage MySQL database. How to create database, tables, how to alter table, add fields, insert records, backup table and backup database.

phpMyAdmin is an open source php script. Download phpMyAdmin from www.phpmyadmin.net and unzip it in "htdocs" directory.

On my PC it is C:\Apache\Apache2\htdocs. Start your browser and type in the Address:

http://localhost/phpMyAdmin/.

phpMyAdmin home page displays. Hover mouse over a thumbnail to see a large image.

phpMyAdmin home page

Contents:
1. How to install Pocket PC emulator on your Windows PC
2. Three columns layout CSS styles for regular PC browsers
3. One column layout CSS styles for mobile device

css styles for mobile device

Pay via PayPal. You should not be concern about my web site security, because when you click the link, you will be redirected to PayPal site and it can be trusted. You will have your financial transaction with PayPal, not with me. So, please do not afraid to buy from my site. Credit cards are accepted. After payment is done, on the PayPal thank you page

click the Return to Merchant link.
You will be redirected to the download page! Also, You will receive email with link to download the tutorial.In case of any problem please contact us:administration@configure-all.com

Three columns layout template created in such a way that the middle column content coming first in the HTML code. This way, Google spider, while visiting your page, will see your main content first. Then the right and the left columns are placed.

In mobile device, web page has only one column. The same web page is used for regular browsers and a mobile device. It is very important because if you create two pages with the same content, Google will punish you for duplicate content.

Download My tutorial in PDF

My tutorials are different from all other tutorials and books because I do not skip initial steps that a reader needed to start learning. Some times, you buy a book and start to read it. You understand everything from the point the author starts, but you do not know how to get to that starting point. I never miss the beginning!

I got error message, because I forgot to start MySQL. I started MySQL and refreshed browser page. A new error message displays:

phpMyAdmin home page

The whole text in the message is:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Ok, let us open config.inc.php file and look at it contents. The config.inc.php file located in phpMyAdmin directory. Open the file in TextPad or Notepad and scroll down to Server Configuration.

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to '  '.
$i++;
$cfg['Servers'][$i]['host']          = 'localhost';       // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';                // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';                // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';          // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;     // Use compressed protocol for the MySQL connection
                                                             // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                             // (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = '';          // access to the "mysql/user"
                                                                 // and "mysql/db" tables).
                                                             // The controluser is also
                                                                 // used for all relational
                                                                 // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'config';     // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';          // MySQL user
$cfg['Servers'][$i]['password']      ='  ';          // MySQL password (only needed)

By default I had root user without password. To protect my database I set password aspirin. That is why phpMyAdmin cannot access my database. Since it is not good practice to use root user in php code let us created a new user.

Read One hour MySQL Tutorial to learn how to create users and set passwords to MySQL.

Login in MySQL as root user.

C:\mysql\bin>mysql -u root -paspirin
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Create a new user

mysql> GRANT ALL PRIVILEGES ON *.* TO 'sergeys'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.25 sec)

mysql>

Now type user name and password in Server Configuration

$cfg['Servers'][$i]['user']='sergeys'; // MySQL user
$cfg['Servers'][$i]['password']='password';// MySQL password (only needed)

Save file. Refresh browser page. phpMyAdmin home page displays:

phpMyAdmin home

Click Databases drop down list. The list of databases displays:

phpMyAdmin list of databases

Select your database and database tables (if any) display:

phpMyAdmin tables

>>Part 2>>


* * *

If you do not like to read from screen you can download all contents of this web site as PDF file, print it out and read it seating in a comfortable chair.

To see the link, you have to be registered visitor. If I did not registered. Please register on my site .