phpMyAdmin & Management articles

phpMyAdmin & Management 405 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 348 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 328 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 322 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 347 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 265 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 252 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 295 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....