Collections:
Testing New User Account and Password in MySQL
How To Test a New User Account and Password in MySQL?
✍: FYIcenter.com
If you have new user created with a password, you test it using "mysql" program with the "-u" and "-p" options. The following tutorial exercise shows you some interesting use cases of connecting to the server with user names and passwords:
>cd \mysql\bin >mysql -u dev ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: NO) >mysql -u dev -pTEST ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password: YES) >mysql -u dev -pretneciyf Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 39 to server version: 5.0.24-community Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Database changed mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | articles | | links | +----------------+ 2 rows in set (0.04 sec)
⇒ Changing Your Own Password in MySQL
⇐ Adding a New User Account in MySQL
2017-09-08, 2078🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...