Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Test a New User Account and Password
How To Test a New User Account and Password? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: 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)
2007-05-10, 4762👍, 0💬
Popular Posts:
What is the output of printf("%d")? 1. When we write printf("%d",x); this means compiler will print ...
What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...
How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...
What are the five levels in CMMI? There are five levels of the CMM. According to the SEI, Level 1 – ...