[2024-feb-29] Sad news: Eric Layton aka Nocturnal Slacker aka vtel57 passed away on Feb 26th, shortly after hospitalization. He was one of our Wiki's most prominent admins. He will be missed.
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
howtos:databases:install_mysql_on_slackware [2013/01/06 04:05 (UTC)] – added REVIEWED comment mfillpot | howtos:databases:install_mysql_on_slackware [2013/02/11 16:49 (UTC)] – [Configure MySQL] wisedraco | ||
---|---|---|---|
Line 27: | 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, | network connections, | ||
- | < | + | < |
# | # | ||
</ | </ | ||
- | + | ||
== 4) Start mysqld == | == 4) Start mysqld == | ||
< | < | ||
Line 85: | Line 85: | ||
mysql> DELETE FROM user WHERE user=''; | mysql> DELETE FROM user WHERE user=''; | ||
</ | </ | ||
+ | |||
+ | == Finish set configfile == | ||
+ | * Go to ''/ | ||
+ | * Edit ''/ | ||
+ | < | ||
+ | [mysqld] | ||
+ | collation-server = utf8_unicode_ci | ||
+ | init-connect=' | ||
+ | character-set-server = utf8 | ||
+ | </ | ||
+ | This gives you full utf8 on your mysql server, after restart it. | ||
+ | |||
===== Troubleshooting ===== | ===== Troubleshooting ===== | ||
Line 93: | 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): | ||
- | < | + | < |
UPDATE mysql.user SET Password=PASSWORD(' | UPDATE mysql.user SET Password=PASSWORD(' | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; | ||
Line 115: | Line 127: | ||
<!-- You must remove the tag-word " | <!-- You must remove the tag-word " | ||
{{tag> | {{tag> | ||
+ |