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 Rename an Existing User Account Name
How To Rename an Existing User Account Name? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this:
>cd \mysql\bin >mysql -u root -pretneciyf mysql mysql> RENAME USER dev TO dba; Query OK, 0 rows affected (0.01 sec) mysql> SELECT User, Password, Shutdown_priv FROM mysql.user; +------+-------------------------------------------+-----+ | User | Password | ... | +------+-------------------------------------------+-----+ | root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y | | dev | *446BD97F308FBA0B9CBDC962C2842AD338BCE59E | N | +------+-------------------------------------------+-----+ 2 rows in set (0.03 sec)
2007-05-10, 4580👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=10, y=15; x = x++; y = ++y...
.NET INTERVIEW QUESTIONS - What is Multi-tasking ? It’s a feature of modern operating systems with w...
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...