[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 03:58 (UTC)] – General cleanup - added tag mfillpot | howtos:databases:install_mysql_on_slackware [2013/02/11 16:49 (UTC)] – [Configure MySQL] wisedraco | ||
---|---|---|---|
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, | network connections, | ||
- | < | + | < |
# | # | ||
</ | </ | ||
- | + | ||
== 4) Start mysqld == | == 4) Start mysqld == | ||
< | < | ||
Line 84: | 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 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): | ||
- | < | + | < |
UPDATE mysql.user SET Password=PASSWORD(' | UPDATE mysql.user SET Password=PASSWORD(' | ||
FLUSH PRIVILEGES; | FLUSH PRIVILEGES; |