≡ Menu

mysql command

Create a MySQL Database, Tables and Insert Data

How do I create a MySQL database, tables, and insert (store) data into newly created tables?
[click to continue…]

MySQL command to show list of databases on server

I am a new Linux user and never used MySQL database server before. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same purpose?
[click to continue…]

Import MySQL Dumpfile, SQL Datafile Into My Database

How can I import a MySQL dumpfile into my database? I'm using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?
[click to continue…]

How can I restore a backup of a MySQL database?

Q. I made MySQL backup using mysqldump -u user -h localhost -ppassword forumdb | -gzip -9 > forumdb.sql.gz command. How do I restore MySQL database backup using a shell prompt under Linux / UNIX operating system?
[click to continue…]

Access MySQL Server From The Shell Prompt (Command Line)

How do I access MySQL server from the shell prompt (command line)?
[click to continue…]

MySQL Change root Password

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX-like like operating system over the ssh session?
[click to continue…]

Mysql User Creation: Setting Up a New MySQL User Account

How do I create a user account on MySQL database server?
[click to continue…]