Difference between revisions of "MySQL server"
(Created page with "===Installation=== ====Required packages==== <syntaxhighlight lang="bash"> apt-get install mysql-server mysql-client </syntaxhighlight> Your database will use InnoDB instead...") |
|||
| Line 82: | Line 82: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
mysql > use mysql ; | mysql > use mysql ; | ||
| − | mysql > select User,Host,Password from user ; | + | mysql > select User,Host,Password from user; |
</syntaxhighlight> | </syntaxhighlight> | ||
====Change root login==== | ====Change root login==== | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
| − | mysql > UPDATE user SET user = | + | mysql > UPDATE user SET user.User = 'admin' WHERE user = 'root'; |
</syntaxhighlight> | </syntaxhighlight> | ||
====Change root password==== | ====Change root password==== | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
| − | mysql > | + | mysql > UPDATE user SET user.Password = password('****') WHERE user = 'admin'; |
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 99: | Line 99: | ||
mysql > flush privileges ; | mysql > flush privileges ; | ||
mysql > select User,Host,Password from user ; | mysql > select User,Host,Password from user ; | ||
| − | mysql > exit | + | mysql > exit; |
</syntaxhighlight> | </syntaxhighlight> | ||
| − | + | ====Check results==== | |
| − | + | <syntaxhighlight lang="bash"> | |
| − | + | mysql –u admin –p | |
| − | + | </syntaxhighlight> | |
| − | |||
| − | |||
| − | |||
Revision as of 21:57, 16 November 2013
Contents
Installation
Required packages
apt-get install mysql-server mysql-clientYour database will use InnoDB instead of the old, deprecated, database file system.
You’ll have to choose a password for MySQL admin [root] user
Configuration
Stop the service (you cannot configure a running service)
/etc/init.d/mysql stopEdit configuration file
vim /etc/mysql/my.cnfEdit the file:
[mysqld]
#bind-address = 127.0.0.1 # Comment this line to enable remote accessRestart service
/etc/init.d/mysql restartCheck running service
netstat -tapyou should have something like:
tcp 0 0 *:mysql *:* LISTEN 3281/mysqld
Enable remote access
Server connection
mysql -u root -p
mysql> use mysql;
mysql> select user,host,password from user;
mysql> update user set host="%" where user="root" and host="vks11447";♠ where 'vks11447' is the server name.
mysql> flush privileges;
mysql> quit;
Restart server
/etc/init.d/mysql restartOpen your firewall
# MySQL server
$IPTABLES -t filter -A INPUT -p tcp -m state --state NEW --dport 3306 -j ACCEPT
Change root login
Change root login / password
mysql -u root -p
Display all users
mysql > use mysql ;
mysql > select User,Host,Password from user;Change root login
mysql > UPDATE user SET user.User = 'admin' WHERE user = 'root';Change root password
mysql > UPDATE user SET user.Password = password('****') WHERE user = 'admin';
Apply changes
mysql > flush privileges ;
mysql > select User,Host,Password from user ;
mysql > exit;Check results
mysql –u admin –p
