MySQL
Latest Article:
The future - a.k.a. What now?
As you may know I have officially joined the ranks of Slicehost as a support/article/helper type bloke (with a dreamy accent to boot!).
So what does that mean for usefuljaja.com?
The MySQL database is the world's most popular relational database for many good reasons:
It's easy to install, easy to learn, powerful and scales from the most basic usage to the most demanding Enterprise level use.
These articles will take you through the very basics of using the MySQL database to optimising your MySQL install for your VPS or Server.
These MySQL hints, tips and tricks will make your life as a developer and system administrator much easier and you will be able to solve issues quickly. Often before they even occur.
MySQL tutorials:
Setting the MySQL root password: One of the first things to be done on installing MySQL is to set the root password.
Reset a lost MySQL root password: So what happens when you lose the MySQL root password? With sudo privileges you can reset it.
MySQL Users:
Creating and editing users: Creating MySQL users and assigning privileges follows the same principles as for system users. Let's see how.
MySQL from the command line:
Listing installed databases: Let's discover what databases are installed by default.
Creating and deleting databases: Creating and deleting schemas is our first step.
Creating and deleting tables: Adding, renaming and deleting tables from our chosen schema is very simple.
Creating records and adding columns: Now we have our database and table, let's add some records and add some more columns.
Exporting and importing databases.: Exporting and importing records to and from databases is very easy to do and takes just one command.
Searching and counting records.: Displaying records is pretty much the whole point of a database. As shown, this is achieved with minimal effort.
Please feel free to contact me with any suggestions or ideas of your own.
PickledOnion
Subscribe to Feed