Ashek with father of Mysql Monty
Mysql database
MySQL is a relational database management system. It runs as a server providing multi-user access to a number of databases.
MySQL is popular for web applications and acts as the database component of the LAMP platforms .The popularity of PHP & Ruby in Rails made MySQl more popular in Web applications.
MySQL Cluster
Is a real-time open source transactional database designed for fast, always-on access to data under high throughput conditions. MySQL Cluster utilizes a “shared nothing” architecture which does not require any additional infrastructure investment and provides 99.999% data availability with no single point of failure. MySQL Cluster is most often used as an in-memory database, but can be used as a disk-based data also.
Cluster automatically and transparently distributes data across multiple data nodes. It delivers extremely fast failover times so your applications can recover quickly.
Install MySQL in ubuntu linux
Open a terminal window, and use the following command
sudo apt-get install mysql-server
If you are running PHP you will also need to install the php module for mysql 5:
sudo apt-get install php5-mysql
To create a new database, use the mysqladmin command:
mysqladmin create
Install LAMP server
Install Apache
sudo apt-get install apache2
Testing HTTP Server by open a web browser and enter http://localhost
Install PHP5
sudo apt-get install php5 libapache2-mod-php5
Stop/Restart Apache
sudo /etc/init.d/apache2 restart
Test the installation
sudo gedit /var/www/testphp.php
Insert this following line into testphp.php file.
Open a web browser and enter http://localhost/testphp.php
Be sure to remove the file afterwards, as it may pose a security risk.
sudo rm /var/www/testphp.php
Install MySQL Server
sudo apt-get install mysql-server
MySQL initially only allows connections from the localhost (127.0.0.1). We’ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Open the file /etc/mysql/my.cnf
gksudo gedit /etc/mysql/my.cnf
Find the line bind-address = 127.0.0.1 and comment it out then save the file.
MySQL comes with no root password as default. This is a huge security risk. You’ll need to set one. So that the local computer gets root access as well, you’ll need to set a password for that too. The local-machine-name is the name of the computer you’re working on.
mysqladmin -u root password newpassword
mysqladmin -h root@local-machine-name -u root -p password newpassword
sudo /etc/init.d/mysql restart
Install MySQL Administrator
sudo apt-get install mysql-admin
Refresh Gnome Panel
Run MySQL Administrator
Applications -> System Tools -> MySQL Administrator
MySQL for Apache HTTP Server
sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin
To get PHP to work with MySQL, open the php.ini file
gksudo gedit /etc/php5/apache2/php.ini
You’ll need to uncomment the “;extension=mysql.so” line so that it looks like this
extension=mysql.so
Restart Apache
sudo /etc/init.d/apache2 restart