Check version of mysql installed

When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:. The server version in this example is From within the MySQL client, you can also run the following command for more details:. If you aren't familiar with running commands through ssh, you may have access to PHPMyAdmin on the server which gives a nice graphical interface for managing the databases.

Liquid Web's High-Availability Databases provides the bleeding edge hardware needed for keeping your site online. Does significantly reducing overhead while not having to worry about managing MySQL sounds like a dream come true? Then check out our affordable plans! Alex Gorzen has been helping others with technology his whole life. He played with computers even before he could read and wants to make sure his children share that same love as they grow up.

In his free time, he enjoys gardening, building things, and learning new skills. After creating the new user, you can set up a new RazorSQL connection to the database using the new user instead of the root user. Once you are connected with your new user, below are some sample commands to create a new table, insert data into the table, and query data in the table.

Double-click the. This will launch the MySQL installer 2. Continue with the default options. At one point during the installation, the installer will ask whether to use strong password encryption or legacy password encryption. Some MySQL tools do not yet support strong password encryption. If the tools you are using to connect to MySQL do not support strong password encryption, select the legacy password encryption option.

Leave a Comment Cancel Reply Your email address will not be published. We can help you. Right now. Fast growing merchants depend ServerGuy for high-performance hosting. Experience counts. Let's get started. Website Name. Contact No. Talk to a sales representative. This statement provides the most comprehensive overview regarding the status of the MySQL installation and its current version.

You now know how to use the command line to check your MySQL version. Additionally, if you need to get a more detailed account of your MySQL version, this article explained how to display additional data from within the MySQL client.

Was this article helpful? Vladimir Kaplarevic. He has more than 7 years of experience in implementing e-commerce and online payment solutions with various global IT services providers.