phpMyAdmin & Management articles

phpMyAdmin & Management 473 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 390 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 389 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 391 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 337 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 322 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 310 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 275 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....