We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
vestacp with mysql 8 under ubuntu 18.04
-
- Posts: 15
- Joined: Tue Feb 05, 2019 7:10 pm
- Os: Ubuntu 17x
- Web: apache
vestacp with mysql 8 under ubuntu 18.04
If you plan on updating mysql to version 8 you must change in vesta config:
1. cd /usr/local/vesta/bin
2. nano v-add-database
3. Search for line
4. Add after:
these lines:
In our tests we had to change the next 2 query lines and make them look like these:
This change should not be a problem.
Very important, mysql must be configured tu authenticate using "mysql_native_password", so in mysql configuration file (/etc/mysql/my.cnf ) under [mysqld] add:
default_authentication_plugin = mysql_native_password
Adding, suspending and deleting database and user works fine. No more changes needed.
1. cd /usr/local/vesta/bin
2. nano v-add-database
3. Search for line
Code: Select all
# Create MySQL database
Code: Select all
query="CREATE DATABASE \`$database\` CHARACTER SET $charset"
mysql_query "$query" > /dev/null
Code: Select all
query="CREATE USER \`$dbuser\`@\`$host\` IDENTIFIED BY '$dbpass'"
mysql_query "$query" > /dev/null
query="ALTER USER \`$dbuser\`@\`$host\` IDENTIFIED WITH mysql_native_password BY '$dbpass'"
mysql_query "$query" > /dev/null
Code: Select all
query="GRANT ALL ON \`$database\`.* TO \`$dbuser\`@\`%\`"
mysql_query "$query" > /dev/null
query="GRANT ALL ON \`$database\`.* TO \`$dbuser\`@localhost"
mysql_query "$query" > /dev/null
Very important, mysql must be configured tu authenticate using "mysql_native_password", so in mysql configuration file (/etc/mysql/my.cnf ) under [mysqld] add:
default_authentication_plugin = mysql_native_password
Code: Select all
[mysqld]
default_authentication_plugin = mysql_native_password
Re: vestacp with mysql 8 under ubuntu 18.04
For an existing install other than backing everything up first, would you update mysql first then make these changes?