MySQL - searching for a record
When the database has more than a handful of records, we need a way of searching for a particular record. The point of a database is to hold the information for us so we don't have to remember it all.
MySQL - exporting and importing records
Whether it is for a quick database backup or to import existing records to a new database for a server move, importing and exporting records is a basic and essential function.
Luckily, saving the data and moving it to a new MySQL database could not be easier.
MySQL - reset a lost root password
There may well be a time where you lose or forget your MySQL root password. This may well, as you can imagine, turn out to be a complete disaster.
OK, so we shouldn't lose root passwords. But what happens if we do?
MySQL - creating and editing users
Adding MySQL users follows the same principles as adding system users. Each user can be assigned different privileges to different databases.
Privileges can range from read only for a single database to full MySQL wide administrator rights.
MySQL - creating records and adding columns
Now we have the database and the first table created we can start adding records.
Again, this is very easy via the command line. We'll also add another column to the table, change existing records and delete unwanted records.
MySQL - creating and deleting tables
Once you have your database created you will want some tables in there.
There are some application frameworks, such as Ruby on Rails, where all you have to do is create the database: the rest is done within the framework itself. However, it is always a good idea to know how to create tables.
MySQL - creating and deleting a database
Following this MySQL series will see us creating a database called 'pickled1', adding tables, columns, rows (data) and specifying MySQL users for the 'pickled1' database.
We can start by deleting any redundant databases and creating our new 'pickled1' database.
MySQL - listing installed databases
Now we have a root password set, let's see what databases are installed by default in MySQL.
Setting the MySQL root password
Setting a MySQL root password is considered by some to be a waste of time. But then some also believe having a firewall or wearing a seatbelt are a waste of time.
Setting a MySQL root password is very simple and is the first thing you should do on installing the MySQL database.
Ubuntu setup - page 3
In page 2 We consolidated the base install and updated the base image, installed the security updates and configured some personal configuration files.
Now we'll install the meat of the server: mysql with Ruby on Rails and subversion support.
Subscribe to Feed