How to Create a MySQL Database?


Cheap reseller Hosting


To Create a MySQL Database

How-to-Create-a-MySQL-Database

MySQL is an open-source relational database management system. It is one of the best RDBMS being used for developing web-based software applications. You have access to root user, you can easy create any database using mysql

In this article will give you how you can easily create a new database from your cPanel. Follow the steps and create a MySQL Database.

Step 1 : Log in your cPanel.

Step 2 : Go to MySQL Databases.

Step 3 : Navigate to the Create New Database box.

Step 4 : Enter the Database Name in the New Database text field.

Step 5 : Click on the Create Database button.

Step 6 : The database name will be preceded by the cPanel username.

Example, if your cPanel user name is user and you want to have a database named test, the actual database name will be user_test.

create_mysql_database

Then, You will get a confirmation message.


Cheap web Hosting


How to Uninstall MySQL Governor


Cheap reseller Hosting


Uninstall MySQL Governor

To uninstall MySQL Governor.

  • Run the following command to uninstall MySQL Governor:

/usr/share/lve/dbgovernor/install-mysql.py –delete
yum erase db-governor db-governor-mysql

 


Cheap web Hosting


Installing LAMP On Linux Mint


Cheap reseller Hosting


Installing LAMP (Linux, Apache, MySQL and PHP) On Linux Mint. 

LAMP stands for Linux, Apache, MySQL, PHP. How to install Linux the L of LAMP.

LAMP_ashishkale_in

Install Apache

To start off we will install Apache.

1) Open up the Terminal

(Applications > Accessories > Terminal)

2) Copy/Paste the following line of code into Terminal and then press enter

sudo apt-get install apache2

3) Type you’re password, and then press enter.

The page should display the words

.

.

.

.

“It works!” 

 

Testing Apache

 

To make sure everything installed correctly we will now test Apache to ensure it is working properly.

1) Open up any web browser and then enter the following line.

http://localhost/

2) You should see a folder entitled apache2-default/.

3) Open it and you will see a message saying 

.
.
.
.
“It works!”, congrats to you!

 

Install PHP

PHP is an open source web scripting language that is widely use to build dynamic webpages.

To install PHP

1) Open up the Terminal

(Applications > Accessories > Terminal)

2) Type in this command

sudo apt-get install php5 libapache2-mod-php5

After you answer yes to the prompt twice, PHP will install itself.

3) It may also be useful to add php to the directory index, to serve the relevant php index files

sudo nano /etc/apache2/mods-enabled/dir.conf

 

Test PHP

To ensure there are no issues with PHP let’s give it a quick test run.

1) Open up the Terminal

(Applications > Accessories > Terminal)

2) Type in this command

sudo gedit /var/www/testphp.php

This will open up a file called phptest.php.

3) Copy/Paste this line into the phptest file:

<?php phpinfo(); ?>

4) Save and close the file.

5) Now open you’re web browser and type the following into the web address:

http://localhost/testphp.php

The page should look
.
.
.

Congrats you have now installed both Apache and PHP!

 

Install MySQL

To finish this guide up we will install MySQL. MySQL is a powerful database management system used for organizing and retrieving data

To install MySQL,

1) Open terminal and type in these commands

sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

During the installation, MySQL will ask you to set a root password. If you miss the chance to set the password while the program is installing, it is very easy to set the password later from within the MySQL shell.

2) Once you have installed MySQL, we should activate it with this command

sudo mysql_install_db

3) Finish up by running the MySQL set up script

sudo /usr/bin/mysql_secure_installation

4) The prompt will ask you for your current root password.

Type it in.

5) Enter current password for root (enter for none)

OK,

.

.

.

successfully used password, moving on…


Cheap web Hosting


Mysql error : Can’t create new tempfile: ‘*.TMD file


Cheap reseller Hosting


mysql
If you are getting error like Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it.
Solution :
You need to just run below command on the shell.
# myisamchk -r -f  tables.MYI
Thats all.

Cheap web Hosting