Enjoy the Holiday season!

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/07 02:26 (UTC)]
mfillpot modified file flags
howtos:databases:install_mysql_on_slackware [2013/02/11 16:51 (UTC)]
wisedraco [Configure MySQL]
Line 85: 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 =====

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