If you use the MySQL database, chances are you are always hunting for a greater tool to make the administration a little bit simpler. Luckily, there are a range of these instruments obtainable. Just one is MyWebSQL. This tool is lesser identified than its competitiveness (these as phpMyAdmin). But this certain tool (which can get the job done with MySQL, PostgreSQL, and SQLite databases) supplies a great WYSIWYG interface for running your database and features these gains:
- It is really compatible with all major world-wide-web browsers.
- You can make/edit table constructions through WYSIWYG.
- It lets you edit and delete numerous data at the same time.
- It features syntax highlighting.
- You can export databases, tables, and query results.
- You can use MySQL-linked instruments.
- Set up is straightforward.
- Zero configuration is vital.
- It is really open source.
The straightforward set up will appeal to a lot of directors. Past that, MyWebSQL has a nice interface that helps make working with your databases virtually effortless. So let’s install MyWebSQL.
What you’ll have to have
I will be setting up MyWebSQL on Ubuntu sixteen.04. Although it can be set up on Ubuntu eighteen.04, the login system would seem to be damaged. It is also probable to install this tool on CentOS (the set up of which is quite related to that of Ubuntu, with only slight modification). With that stated, you’ll have to have a jogging LAMP (Linux Apache MySQL PHP) server. In this occasion, the “L” part will be Ubuntu Server sixteen.04. You can also have to have to have a consumer who can log into the MySQL prompt (be that root or yet another consumer).
SEE: Securing Linux policy (Tech Professional Investigate)
Only a number of dependencies are vital. Open up up a terminal window and concern the subsequent commands:
sudo apt install wget zip sudo apt install php-pgsql
Once those people dependencies install, obtain the vital file with the command:
Unzip and permit
Just after the zipped file downloads, unzip it with the command:
unzip mywebsql-three.seven.zip -d /var/www/html/
Now give the directory the vital permissions with these commands:
sudo chown -R www-information:www-information /var/www/html/mywebsql/ sudo chmod -R 775 /var/www/html/mywebsql/
Restart and look at
It is really time to restart Apache. Do so with the command:
sudo systemctl restart apache2
With the world-wide-web server restarted, let’s look at to make absolutely sure we have everything set up. Point a world-wide-web browser to http://SERVER_IP/mywebsql/install.php (the place SERVER_IP is the precise IP handle of your server). You need to see a webpage that lists the output of many environment assessments (Determine A). If there are any failures, handle them and refresh this webpage.
As you can see, I don’t have the SQLite consumer library set up. That is wonderful, as I am not utilizing MyWebSQL for SQLite. Once everything has passed, place your browser to http://SERVER_IP/mywebsql/ and log in with your MySQL username and password. You need to then land on the primary MyWebSQL webpage (Determine B).
That is all there is to setting up this perfectly-built, world-wide-web-dependent database administration tool. Kick the tires of MyWebSQL and see if it isn’t going to quite speedily come to be your go-to MySQL admin tool.