Kurinchi Blogger Scribbles …


Posts Tagged ‘phpMyAdmin’

Mar 26
2011

MySQL: Default collation latin1_swedish_ci (swedish case insensitive)

Last updated: March 26th, 2011

When new fileds are created as variable characters they get stored as latin1_swedish_ci as default. To change the default collation users will have to manually select the collation of their choice from the mysql admin interface such as in the case of phpmyadmin or will have to denote it in sql queries.

To make a specific collation as the default, other option to give mysql an indication of it by having the needed collation name in my.cnf (mysql configuration) as shown below

Edit my.cnf:
[mysqld]
collation_server=latin1_general_ci

(more…)

Jan 09
2011

MySQL Database Error: Error 28 from Storage engine

Last updated: January 9th, 2011

Reason for the error is the availability of space allocated to the MySQL database in the specified partition.

Easy fix for this is to go to the PhpMyAdmin interface (via CPanel/WHM) and identify the tables which has some value in under overhead column. Select ALL those tables and choose the option “Repair table” after you ensure that there is enough space in the database.

Mar 12
2010

Ubuntu: Configure PHPMyAdmin in Simple Steps

Last updated: March 17th, 2010

$ sudo apt-get install phpmyadmin

For versions 7.10 and up, choose “Apache 2″ from the screen “Configuring phpmyadmin”

If everything goes fine, you can access phpmyadmin from
http://servername/phpmyadmin

If you have created users in MySQL, you can use those credentials to log into the database. The basic admin account is “admin” with no password.

Phpmyadmin defaults to requiring you to login after 1800 seconds of inactivity.

» MySQL Create User, Grant Rights http://kurinchilamp.kurinchilion.com/2009/04/mysql-create-user-grant-rights.html

Dec 24
2008

phpMyAdmin – visual interface for MySQL on Windows/Linux

Last updated: April 14th, 2009

phpMyAdmin is a web based interface to MySQL which is written using PHP for Administration of databases. Visual interface provided is intuitive and it saves time for the developers. (ver 3.1.1 is the recommended version as of this writing which runs on PHP 5/MySQL 5)

Step 1: First we need to check MySQL is installed by issuing the following command
[root@user Desktop]# which mysql

If you get …
/usr/bin/mysql
then, it is an indication that MySQL is installed in your machine. (more…)


Valid HTML 4.01 Strict  Valid HTML 4.01 Strict