Verbosity Value 1 Errors only, 2 Errors and warnings, 3 Errors, warnings, and notesĭatadir="c:/wamp64/bin/mysql/mysql8.0.18/data" Added to reduce memory used (minimum is 400)īasedir="c:/wamp64/bin/mysql/mysql8.0.18" This section has the name of the serviceĭefault_authentication_plugin=mysql_native_password name for use by the server installed with that service name. be used by all MySQL services, and an option group with the service This enables you to use the group for options that should that has the same name as the service in the standard option files. It reads options from the group and the group than MySQL following the -install option, the server uses that If the service-installation command specifies a service name other Here follows entries for some specific programs The following options will be passed to all MySQL clients If you want to know which options a program supports, run the program In this file, you can use all long options that a program supports. For information about these locations, see: You can copy this option file to one of those locations which depend on the deployment platform. MySQL programs look for option files in a set of Here’s what the modified my.ini looks like: Luckily, I backed up the original my.ini file to my desktop. I saved it and restarted WAMP, but WAMP wouldn’t start up all the way, it got stuck on orange. It opened in Notepad++ and I did a find and replace for all the “3308” into “localhost:3308”. I went into WAMP, MySql 8.0.18, and edited the “my.ini” file. I edited the privileges as previously suggested on the newly created testdb, and still got “Can’t select database”. I created a new database with the name “testdb”, and still got “Can’t select database”. If all else fails you may find help at the WordPress Support Forums.
If you don’t know how to set up a database you should contact your host. On some systems the name of your database is prefixed with your username, so it would be like username_test_db. We were able to connect to the database server (which means your username and password is okay) but not able to select the test_db database.ĭoes the user root have permission to use the test_db database? I’m still getting the same error message at wp install:
Note: You are attempting to edit privileges of the user with which you are currently logged in. PhpMyAdmin is giving me a caution message: I’ve tried to check the box by itself and when I click go it doesn’t stay checked.
It updated all the privileges, EXCEPT under Database-specific privileges, Administration, the GRANT box won’t stay checked. I did as you suggested and edited the privileges (non of the boxes were checked).
0 kommentar(er)
