QA:Testcase MySQL or MariaDB in phpMyAdmin

From FedoraProject

Revision as of 08:44, 29 April 2013 by Hhorak (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose of this test is to ensure that phpMyAdmin, a web-based administration tool for managing MySQL-like database written in php, works fine with MySQL and MariaDB databases.

Prerequisities

For testing MariaDB you should either use Fedora 19 or enable Fedora 18 testing repository with necessary MariaDB packages.

Recommended: For more valuable results you should have some existing databases already initialized. The more record the databases have the better value the test will have.

Steps

1. Install necessary packages

# yum install phpMyAdmin mariadb-server

2. Run mysqld and Apache server locally (if not testing remote MySQL/MariaDB server)

# systemctl start mysqld httpd


3. Create a user that you want to use to connect to the database in phpMyAdmin (root doesn't have to be created, but be very careful about connecting to a database with root permissions). Also, root doesn't have a password set by default; consider setting a password using mysqladmin.

4. Configure phpMyAdmin to allow you to log in, i.e. edit /etc/phpMyAdmin/config.ini.php:

4a. Example of simple configuration really only for testing purposes (which allows logging in without a password set):

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

4b. Example of a bit more safe configuration (which requires to have set a password for a user that will be used):

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = FALSE;

5. Open your browser and log in to phpMyAdmin at http://localhost/phpmyadmin

6. Try out some of the following items:

  • create a new database
  • create a new user with various permissions (you need to have enough privileges)
  • create a table and insert some data into it
  • export and import data from/into a table
  • change server variables
  • do anything what comes to your mind

Expected behaviour

All tasks with phpMyAdmin should work without unexpected warnings and changes in the database should be proceeded (you can check this using cli interface).