MySQL

How to tutorials and information about the open source database MySQL. Topics on how to install, confure and use MySQL.

In this tutorial we cover how to install and configure WordPress on a Ubuntu server. I will assume you already have Apache, MySQL, PHP (LAMP), and phpMyAdmin running on your Ubuntu machine.

PhpMyAdmin is a great easy to use web admin interface for your mysql databases. The one down side is it can be a security threat. Seems like many bots on the internet just go looking for phpmyadmin installed on web servers. Then run automated attacks. 

If you have logwatch installed you may often see many failed attemtps.

 

Often when you setup multiple websites on a single web server it can be difficult to figure out what database your Joomla site is using. Some times admins get lazy and create poor names or a hosting provider may just give you a random generated database name. In this tutorial we will look at four different methods on how to find the database name of your Joomla site.

If you are looking for information on what is the mysql database username and password are set to, use the "Find Your Joomla Database Name and Login Information with SSH:" steps below.

(Note: Joomla 1.7 was used in the following examples. The same steps should apply to other versions as well.)

 

 

In this tutorial we will cover how to start, stop, and restart Apache and MySQL on CentOS. Since CentOS is used mostly for a server we will do these steps all at the command line (terminal). We will also use another command to check the status of the services to make sure they are really up or down. Let's get started!

 

 

Most system admins keep servers pretty slim with no Graphical User Interface (GUI). We will stick with the basics and use a few commands to start, stop, and restart Apache as well as some related services on Arch Linux.

Ubuntu Server 10.04 (LTS) is an amazing server. The apt-get package manager makes things very easy to install and offers a large repository of open source software.

In this tutorial we will cover how to start, stop and restart your Apache web server and MySQL db on Ubuntu. Since most Linux servers do not have a graphical user interface installed we will do the steps in a terminal.

In this tutorial we will install Ubuntu Server 11.04 and set it up as web server.In later articles we will use this Ubuntu server to setup websites using wordpress, joomla, drupal and a handful others.

PhpMyAdmin is a web interface to your MySQL databases. It makes managing, creating and configuring your MySQL database a breeze. It is a very common tool and is often installed by default by many web host. In this article we will cover on how to install phpMyAdmin on Ubuntu Server 10.04 (LTS). You will need to already have the LAMP stack installed for these steps to work and have your MySQL root password handy. If you need help on how to install LAMP (Linux, Apache, MySQL, and PHP) please visit the following article:

http://mixeduperic.com/ubuntu/how-to-install-lamp-on-ubuntu-linux-apache-mysql-and-php-in-one-command.html

For security reasons I recommend restricting access to phpmyadmin from a specific internal IP address.

sudo apt-get install phpmyadmin

 

Lamp stands for Linux, Apache, MySQL and PHP. These tools are very common for running many websites such as WordPress, Drupal, Joomla, Collabtive...etc. In Ubuntu we can easily install Apache2, MySQL and PHP with one simple command. In later articles we will later setup some of these open source web applications and use the complete LAMP server. If you are interested in following some of theses tutorials please subscribe to the RSS feed.

Since by default the Ubuntu server does not have a GUI we will install LAMP with the command line. If you do have a GUI installed, you can open a terminal and issue the following commands. This goes for your desktop as well. Lets get started.

sudo apt-get install lamp-server^

 

Pages

Subscribe to RSS - MySQL