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, 4713👍, 0💬
Popular Posts:
What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
it will be very helpful if you send some important Questions with Answers of DBMS Tell us what types...
What is the FP per day in your current company?
Can you explain in brief how can we implement threading ? Private Sub Form1_Load(ByVal sender As Sys...