10 Best Sql Server Training

Best Sql Server Training in 2023

---

---

---

---

---

---

---

---

---

---

---

Connecting to MySql Server from Commandline

Learn how to connect to MySql server from commandline.

C:/ gt; mysql -u user_name -p -h host_name

If the user_name is root and host_name is 192.168.1.3(location of mysql server) then the command would be written as

C:/ gt;mysql -u root -p -h 192.168.1.3

Next, you will be asked for a password

Enter password:****

Type the password and press enter.

One may also specify database name during connection

C:/ gt;mysql -u user_name -p -h 192.168.1.3 db_name

Different formats

1. C:/ gt;mysql -uroot -proot -h192.168.1.3 student_db

2. C:/ gt;mysql --user=root --password=root --host=192.168.1.3 student_db

student_db is a database name.

Above formats are all valid ways of connecting. However, note that you cannot say -p root, that would throw an error.

Try C:/ gt;mysql -u root -p root -h 192.168.1.3

What do you get? You would be prompted for a password then an error would be thrown.

If you don't want to type the password on the commandline, you could always ask the commandline to prompt you for a password.

C:/ gt;mysql -u root -p -h 192.168.1.3

Or

C:/ gt;mysql -u root --password -h 192.168.1.3

Next you will be asked to enter a password.

The clients used for connecting to a server can be commandline, gui etc. Each may have different program specific parameters to setup a connection. But some parameters are common in all.

Some of the common parameters are :

The first two parameters are used for user identification.