[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.
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | howtos:databases:install_mysql_on_slackware [2012/09/26 02:35 (UTC)] – moved from the general howtos namespace mfillpot | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <!-- Add your text below. We strongly advise to start with a Headline (see button bar above). --> | ||
+ | ====== Install MySQL On Slackware ====== | ||
+ | == INSTALL MySQL == | ||
+ | |||
+ | Install MySQL from the official Slackware discs or using [slackpkg]. | ||
+ | |||
+ | |||
+ | == CONFIGURE MySQL == | ||
+ | |||
+ | 1) Create the needed database(s) and set their permissions properly. As root, run: | ||
+ | |||
+ | | ||
+ | |||
+ | User specified by '' | ||
+ | |||
+ | 2) Enable execution of rc script to start MySQL automatically on boot: | ||
+ | |||
+ | chmod 755 / | ||
+ | |||
+ | 3) Enable networking if needed | ||
+ | |||
+ | Networking is disabled by default to improve security. If you want to allow network connections, | ||
+ | # | ||
+ | |||
+ | 4) Start mysqld: | ||
+ | |||
+ | / | ||
+ | |||
+ | //NOW YOU HAVE A CHOICE - MANUAL INSTALL OR AUTOMATIC// | ||
+ | |||
+ | AUTOMATIC: | ||
+ | |||
+ | 5) 6) 7) Run the following, answer the questions: | ||
+ | |||
+ | / | ||
+ | Initial root password is "" | ||
+ | |||
+ | MANUAL: | ||
+ | |||
+ | 5) Set a password for MySQL' | ||
+ | |||
+ | | ||
+ | |||
+ | |||
+ | 6) You can connect to your MySQL server with: | ||
+ | mysql -u root -p | ||
+ | |||
+ | |||
+ | 7) For security reasons you should delete an empty user for localhost server | ||
+ | |||
+ | | ||
+ | | ||
+ | | ||
+ | |||
+ | == TROUBLESHOOTING == | ||
+ | 1) Server start errors can be seen in the error log that is located by default at ''/ | ||
+ | | ||
+ | / | ||
+ | | ||
+ | 2 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(' | ||
+ | FLUSH PRIVILEGES; | ||
+ | |||
+ | Save this file (any name would do) and start the server with the --init-file argument: | ||
+ | | ||
+ | / | ||
+ | | ||
+ | |||
+ | ====== Sources ====== | ||
+ | |||
+ | * Originally written by [[wiki: | ||
+ | <!-- If you are copying information from another source, then specify that source --> | ||
+ | <!-- * Original source: [[http:// | ||
+ | <!-- Authors are allowed to give credit to themselves! --> | ||
+ | <!-- * Contributions by [[wiki: | ||
+ | |||
+ | <!-- Please do not modify anything below, except adding new tags.--> | ||
+ | <!-- You must remove the tag-word " | ||
+ | {{tag> |