phpMyAdmin & Management articles

phpMyAdmin & Management 1,924 Creating databases and using phpMyAdmin Almost every site that isn't just static pages needs a database. In cPanel you create one in about a minute - and...
phpMyAdmin & Management 1,488 Where each application keeps its database connection details Every website that stores anything has, somewhere in its files, four lines holding the database name, the user, the...
phpMyAdmin & Management 1,384 Finding out which database this WordPress uses The account lists five databases and none of the names says anything. You need to know which one belongs to the...
phpMyAdmin & Management 1,351 Cleaning and optimising the database in phpMyAdmin A site with a few years behind it carries a database full of things nobody reads: a revision of every single save,...
phpMyAdmin & Management 1,369 The database has grown: where to see its size, and what can go One day you notice the account is fuller than it should be, and that a good part of it is the database. The right...
phpMyAdmin & Management 1,392 Emptying a database without deleting it You are about to reinstall the application and you want a clean start. The obvious route looks like deleting the...
phpMyAdmin & Management 1,133 Creating a database user and giving it the right privileges A database without a user is no use to anyone, and a user with too many privileges is an open door. In cPanel you do...
phpMyAdmin & Management 1,268 Database indexes in phpMyAdmin: the types, the column order, and how to add one An index is a sorted list of one column (or several) that the database consults instead of reading the whole table....