https://training-course-material.com/index.php?action=history&feed=atom&title=MySQL_Administration_Server_Files_and_ScriptsMySQL Administration Server Files and Scripts - Revision history2026-05-13T23:35:56ZRevision history for this page on the wikiMediaWiki 1.45.1https://training-course-material.com/index.php?title=MySQL_Administration_Server_Files_and_Scripts&diff=23971&oldid=prevCesar Chew at 18:15, 24 November 20142014-11-24T18:15:45Z<p></p>
<p><b>New page</b></p><div>{{Cat|MySQL|020}}<br />
<br />
<slideshow style="nobleprog" headingmark="⌘" incmark="…" scaled="true" font="Trebuchet MS" ><br />
;title: MySQL Administration Server Files and Scripts<br />
;author: Bernard Szlachta (NobleProg Ltd)<br />
</slideshow><br />
<br />
== MySQL Server Files and Scripts ==<br />
* MySQL Programs<br />
* Server Programs<br />
* Client Programs<br />
* GUI and other tools<br />
<br />
== MySQL Programs ==<br />
=== SERVER ===<br />
* mysqld - the MySQL server<br />
* mysqld_safe - a script which starts mysqld, recommended of starting the server<br />
** restarts the server when an error occur<br />
** logs run-time and failure information <br />
* mysqld_multi - script that can start or stop multiple servers installed on the system (different ports or sockets)<br />
<br />
=== CLIENT ===<br />
* mysql - a command line client<br />
* mysqladmin - administrative operations<br />
** relading the grant tables<br />
** creating/dropping database<br />
** flushing tables to disk<br />
** managing log files<br />
** shutdown the database<br />
* mysqlcheck - repairs, analyzes and optimizes tables<br />
* mysqldump - dumps into SQL, text or XML files<br />
<br />
== MySQL Programs ==<br />
TODO: update it to current version 5.6 or newer<br />
<br />
== Ways of starting a server ==<br />
Windows or Unix service<br />
* sudo /etc/init.d/mysql start<br />
Mysqld_safe<br />
* sudo mysqld_safe<br />
Command line mysqld<br />
* sudo mysqld<br />
<br />
== Stopping MySQL Server ==<br />
Windows/Unix Service<br />
* sudo /etc/init.d/mysql stop<br />
* sudo service mysql stop<br />
* net stop mysql (Windows)<br />
mysqladmin<br />
* mysqladmin -u root -p shutdown<br />
<br />
== Changing Forgotten Password ==<br />
mysqld --skip-grant-tables<br />
# server starts without using the privilege system at all<br />
mysqladmin flush-privileges or <br />
mysqladmin reload or<br />
FLUSH PRIVILEGES<br />
# Change your password<br />
set password for root@localhost = password('asdfasdf')<br />
<br />
== Changing Forgotten Password ==<br />
In order to prevent external connections accessing the databases you can change the port and the bind interface<br />
mysqld --bind-address=127.0.0.1 --port 333 --skip-grant-tables<br />
You can connect to the database with the command below<br />
mysql -P 333 -h 127.0.0.1<br />
<br />
== Running Scripts ==<br />
Execute a script<br />
mysql> source filename<br />
cat filename | mysql (Unix only)<br />
type filename | mysql (Windows only)<br />
mysql < filename<br />
GUI Tools<br />
Running a SQL statement from shell<br />
echo "select * from EMP;" | mysql test;<br />
Saving errors to a file<br />
mysql --force < tables.sql 2> error.log<br />
<br />
== Using Client Tools ==<br />
System Variables<br />
SET USER=your_name (Windows), in Unix the currently logged in user in the system<br />
MYSQL_TCP_PORT=3306; export MYSQL_TCP_PORT<br />
mysql –u user –ppassword –h host database<br />
Config file (my.ini or /etc/mysql/my.cnf)<br />
[client]<br />
host=host_name<br />
user=user_name<br />
password=your_pass</div>Cesar Chew