This lesson you learn  how to the execute mysql file. MySQL  Provide the  executable file and uses the MySQL Client  interactive file by  this command “shell> mysql db_name “. It is possible put the SQL statement in file and tell the mysql from input read this file . So the create  text file ” text_file” . MySQL use the this command for file execute. It is use this command in MySql execute file this type :-

MySQL is a simple SQL shell.  This SQL shell supported the interactive and non- interactive  used. MySQL  when use the interactive quarry then result represent in an ASCII table format. And if you are used the non-interactive quarry then result display the tab-separated format .    

In this command if you use the first line statement db_name then it is  very important to specify for database name on the command line. 

There are already running mysql then you can execute the SQL Script using the source or \ command :

If you want to your script display the progress information to the user then you can insert the this command.

SELECT ‘<info_to_display>’ AS ‘ ‘;

MySQL Executable file:
The MySQL file in this directory is name Apache and execute the file it is operating system X will run during the startup process. This file first thing is that both file and the directory  named Apache. MySQL has execute the file same name as the subdirectory and it is executable in the root level of subdirectory .When are MySQL use the apache HTTP server then display the Massage on the apache Web server.

This MySQL provide the new creating account or  you want to change the password then make new user .This lesson you learn how to create new password.  Mysql as the intended username and the group the next available the UID, the user alternative e-mail address etc. The user need to require to a group that does not exit yet, then first create the group with editing /etc/group manually.  MySQL create new user account use the login “data” and use the adduser command . And you can choose the password “admin” for this user account .

Creating a new user Account 

MySQL is also provide this code for if you want to create new account to login name database and connected the MySQL root. Here code is follow:- 

MySQL Deleting  User Account 
The MySQL User account you want to delete then enter the completely it is not recommended that you do. if you can change the  password to same random to be string . the better way is to change the login shell . It is done by logging in data and using  the vipw command to enter the password file to run make the /var/yp /directory after you make.