Abhishek Kumar Sagar 2K15/MC/04
ASSIGNMENT – 1
What is MySQL?
MySQL is an open-source relational database management system(RDBMS). MySQL is a database system used on the network. Its name is a mixture of “My”, the forename of co-founders Michael Widenius’s son, and “SQL”, the abbreviation for Structured Query Language. It is best for both minor and major applications. MySQL is very fast, reliable, and easy to use. It compiles on a number of platforms. It is allowed to download and use. MySQL is developed, spread, and backed by Oracle Corporation The MySQL development project has made its source code available under the positions of the GNU General Public License, as well as under a difference of properiatry agreements. MySQL was owned and backed by only for-profit firm, the Swedish corporation MySQL AB, now owned by Oracle Corporation. For copyrighted use, several paid versions are accessible, and offer additional functionality. MySQL is a database system that runs on a server.
Installing MySQL Server on Linux
Install the mysql-server package, using either software administration tool you prefer. This automatically causes the MySQL command-line utilities to be connected.
To install MySQL Proxy, use the package mysql-proxy.
MySQL on Linux Depends on an Email Service: The MySQL service uses the local email service to report messages. For this reason, installing MySQL on an Ubuntu system also install an email service.
Installing MySQL on Windows
The default installation on any version of Windows is now much simple than it used to be, as MySQL now comes exactly packaged with an installer. Simply download the installer package, unzip it anywhere and run the setup.exe file. The default installer setup.exe will march you through the trivial process and by default will install everything under C:mysql. Test the server by kicking it up from the command prompt the first time. Go to the location of the mysqld server which is probably C:mysqlin, and type: mysqld.exe –console
NOTE: If you are on NT, then you will have to use mysqld-nt.exe instead of mysqld.exe If all went well, you will see some messages about startup and InnoDB. If not, you may have a agreements issue. Make sure that the directory that holds your data is accessible to whatever user (probably MySQL) the database processes run under. MySQL will not add itself to the start menu, and there is no mostly nice GUI way to stop the server either. Therefore, if you tend to start the server by double clicking the mysqld executable, you should remember to halt the process by hand by using mysqladmin, Task List, Task Manager, or other Windows-specific means.
Running and Shutting down MySQL Server
First check if your MySQL server is running or not. You can use the following command to check it: “ps -ef | grep mysqld”
If your MySql is running, then you will see mysqld process listed out in your result. If server is not running, then you can start it by using the resulting command:
“[email protected]# cd /usr/bin”
Now, if you want to shut down an now running MySQL server, then you can do it by using the following command:
[email protected]# cd /usr/bin
./mysqladmin -u root -p shutdown
Enter password: ******
Create Database Using mysqladmin
You would need distinct privileges to create or to delete a MySQL database. So assuming you have access to the root user, you can create any database using the mysql mysqladmin binary.
Here is an easy example to create a database called TUTORIALS –
[email protected]# mysqladmin -u root -p create TUTORIALS
This will create a MySQL database called TUTORIALS.