MySQL software is a DBMS (Database Management System) or database management system. Lots of MySQL users in this world, many of them using MySQl for data storage of the applications they create. MySQL uses the Client-Server model, which required 1 computer used to put MySQL in force as the server is ready to receive and cater to demand from the client. Installation of Mysql yourself on debian is fairly easy. Here’s how its installation:
- Installation Of MySQL Server. The command below to install mysql and its dependecies.
# apt-get install mysql-server
or
# aptitude install mysql-server
Exploration: MySQL Server mysql: command to interact with the mysql server /var/lib/mysql/: the default storage of mysql database, each custom-made ditaro here :/etc/mysql/my.cnf configuration file of mysql server (global) /etc/init.d/mysql: Daemon script used to start/restart/stop mysql server 2. Check mysql which are running:
# netstat -plantou | grep -i mysql
Output
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2603/mysqld off (0.00/0/0)
3. A connection to the MySQL Server
# mysql -u root -p
See the mysql version goes into mysql, and then type the following command to see the version of the mysql server:
select version();
Start, stop, and restart the mysql service .Command to start the service mysql server:
# /etc/init.d/mysql start
The command to restart the service mysql server # /etc/init.d/mysql restart command for stop service mysql server: # /etc/init.d/mysql stop After the installation process mysql server will run in a daemon, and automatically run when the startup process.
