Enjoy Slackware 15.0!

Welcome to the Slackware Documentation Project

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
howtos:databases:install_mysql_on_slackware [2013/01/06 03:58 (UTC)]
mfillpot General cleanup - added tag
howtos:databases:install_mysql_on_slackware [2013/02/11 16:51 (UTC)]
wisedraco [Configure MySQL]
Line 1: Line 1:
 +<!-- Reviewed 2012-01-05 mfillpot -->
 <!-- Add your text below. We strongly advise to start with a Headline (see button bar above). --> <!-- Add your text below. We strongly advise to start with a Headline (see button bar above). -->
 ====== Install MySQL On Slackware ====== ====== Install MySQL On Slackware ======
Line 26: Line 27:
 Networking is disabled by default to improve security. If you want to allow Networking is disabled by default to improve security. If you want to allow
 network connections, comment out this line in ''/etc/rc.d/rc.mysqld'' network connections, comment out this line in ''/etc/rc.d/rc.mysqld''
-<file>+<file sh rc.mysqld>
 #SKIP="--skip-networking" #SKIP="--skip-networking"
 </file> </file>
- +
 == 4) Start mysqld == == 4) Start mysqld ==
 <code> <code>
Line 84: Line 85:
 mysql> DELETE FROM user WHERE user=''; mysql> DELETE FROM user WHERE user='';
 </code> </code>
 +
 +== Finish set configfile ==
 +  * Go to ''/etc/mysql'' folder, and choose config, who you prefer ( for simple variants without heavy mysql load,if you have 2+ Gb RAM, i recommend my-large.cnf) and copy it to \ as ''/etc/my.cnf''.
 +  * Edit ''/etc/my.cnf'' adding these lines after [mysqld]:
 +<code>
 +[mysqld]
 +collation-server = utf8_unicode_ci
 +init-connect='SET NAMES utf8'
 +character-set-server = utf8
 +</code>
 +This gives you full utf8 on your mysql server, after restart it.
 +More on this described there:[[http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf8-in-my-cnf]]
  
 ===== Troubleshooting ===== ===== Troubleshooting =====
Line 92: Line 105:
  
   * Resetting the root password can be done by creating a new cnf file and add the following lines (please change the password in this example):   * Resetting the root password can be done by creating a new cnf file and add the following lines (please change the password in this example):
-<file>+<file sql mysql_new.cnf>
 UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
 FLUSH PRIVILEGES; FLUSH PRIVILEGES;

In Other Languages
QR Code
QR Code howtos:databases:install_mysql_on_slackware (generated for current page)