Useful to find out which user is using most ressources when MySQL is using a lot of server ressources. Gives you a rundown of all processes using the MySQL database and to which user they belong. INSERT INTO customers VALUES ('Bob', 'Canada', '') For example, if we use the previous customer table, here's a sample entry :
VAR1 VAR2 and VAR3 represent the content that will go in each columns defined when creating the table. INSERT INTO table_name VALUES ('VAR1', 'VAR2', 'VAR3') Show the tables available in the selected database *You can find a list of data types for MySQL here : For example, if someone wants to create a table to list his customers :ĬREATE TABLE customers (name VARCHAR(35), country VARCHAR(20), registered DATE) Please note that all commands must end with the « » character:Ĭreates a database with the specified nameĬREATE TABLE table_name ( field1_name TYPE(SIZE), field2_name TYPE(SIZE)) Ĭreates a table inside the selected database with the appropriate parameters. Here is a list of useful MySQL commands that will help manage your server. Second Step : Using commands to manage the server. Once you're logged into the mysql server, you should see an interface similar to this :įrom here, we can start querying the MySQL server. This will, however, not be covered in this article. It can also be reset through other means depending on your operating system. If you're using cPanel, it can be found in the /root/.my.cnf file. If installed manually, it's generally the same as the root password. The MySQL root password is normally set when installing MySQL. Once the command is entered, you will be prompted for a password. This command lets you access the database as root, which means you will have administrator privileges. Once you're connected to the server, you need to enter the following command (please first open a command line window if you're connected to a Windows server): You can also access it by doing a direct connection to the MySQL database, but this is more advanced and will not be covered here.
You will first need to access the server through either SSH in Linux, or through Remote Desktop in Windows.
Here is how to first access the MySQL command line interface, how to use many useful commands, how to use the select command to query the database, and how to do a database backup.įirst Step : Accessing the MySQL server through command line. However, clearly the most powerful and efficient way to manage a MySQL server is directly through command line. There are countless frontends, such a PHPMyAdmin and MySQL Workbench. There are many ways to manage a MySQL server.
0 kommentar(er)
