If you have an account with SYSTEM_USER privileges (like the root account, for example), you can delete any database you want. You need to use a user account with sufficient privileges to delete a database. SPanel will automatically redirect you to the command-line interface and open a shell. You can log in to the User Interface and open the SSH Terminal. If you use SPanel, you have a third option. Although native SSH support is now available on all operating systems, some people continue to prefer dedicated clients because of the additional features and the ability to easily access saved sessions. If the server uses a custom SSH port (the default one is port 22), you need to add -p followed by the port number.Īfter successful authentication, the server will start the session.Ī second option would be an SSH client application like PuTTY. The command for starting an SSH session looks like this: If you use Windows, you can choose between Command Prompt or PowerShell, and if you’re on a Unix-based OS, you have the default Terminal as well as a number of third-party applications with the same functionality. You can use your operating system’s command-line tool. There are several options for establishing an SSH connection. Those of you with less experience may be a bit intimidated by the prospect of using commands, but the truth is, if you approach the task meticulously, you’ll see that there’s little to go wrong.ĭeleting a MySQL database involves several steps, which we’ll now go into.ġ. The traditional way to delete MySQL databases is via the command line. Deleting a MySQL Database Through the Command-Line Interface Most likely, your project uses it as well, and you may have not one but multiple MySQL databases on your hosting account.īut what do you need to do if you want to get rid of one of them? The relational database management system powers most web applications and is integral to almost all modern websites.
0 kommentar(er)
