Differences

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

--- 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='';
 </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 =====