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, 2079🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...