Databases :: MySql :: New Install - Change Password / Describe Users |
|||
By: Squibi  |
Date: 12/04/2003 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
I am a beginner with MySQL and have just installed v4.0.12. I am trying to understand what accounts get set up OOTB, but don't know how to query the dB for a list of pre-defined USERS. I assume that there is a USER called "root" since I ran the following command to try and change the password: mysqladmin -u root password newpw Now, I can't get to a "mysql>" prompt. I get an error "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) 1) Can someone tell me what exactly I have done and how to correct it? 2) How can I query the USERS table to find out what accounts are built OOTB so that I can secure them? |
|||
| By: VGR | Date: 13/04/2003 05:57:00 | |
Type : Answer |
| 1) you've now to access the mysqld by issuing : mysql --user=root --password=newpw 2) after connection : use mysql; select * from user; (or select Host,User,Password from user; ) |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
