View previous topic :: View next topic |
Author |
Message |
genitus Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
Joined: 07 Jun 2007 Posts: 87 Location: Europe
|
Posted: Thu Jul 26, 2007 9:24 pm Post subject: [solved]list existing mySQL accounts ? |
|
|
i couldn't find that fast enough , seems like that question is not answered where it should be .
i just want to list all existing users with as much information as possible .
greetings
Last edited by genitus on Fri Jul 27, 2007 4:59 pm; edited 1 time in total |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
elgato319 Guru
![Guru Guru](/images/ranks/rank_rect_3.gif)
Joined: 15 Sep 2005 Posts: 546
|
Posted: Thu Jul 26, 2007 9:44 pm Post subject: |
|
|
Code: |
mysql -h 127.0.0.1 -u root -p
use mysql;
select * from user;
select * from db;
|
|
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
genitus Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
Joined: 07 Jun 2007 Posts: 87 Location: Europe
|
Posted: Fri Jul 27, 2007 12:31 am Post subject: |
|
|
thanks .
so i guess the mysql database is the administration db , even if i don't use it manually ?
is there something to limit the output on viewable amount (if i use a field wildcard like *) ?
well , the more important problem is that the password shows up in encrypted code - how can i see it in cleartext ? |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
elgato319 Guru
![Guru Guru](/images/ranks/rank_rect_3.gif)
Joined: 15 Sep 2005 Posts: 546
|
Posted: Fri Jul 27, 2007 6:53 am Post subject: |
|
|
Code: |
select * from user LIMIT 0, 10;
|
will show only the first 10 entrys
Code: |
select * from user LIMIT 10, 10;
|
will show the next 10 entrys
Quote: |
well , the more important problem is that the password shows up in encrypted code - how can i see it in cleartext ?
|
you can't, thats why they are encrypted
you can use the root account (mysql account NOT linux account) to set a new password for a user |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
nobspangle Veteran
![Veteran Veteran](/images/ranks/rank_rect_5_vet.gif)
![](images/avatars/210249061640b0c1d626f5b.gif)
Joined: 23 Mar 2004 Posts: 1318 Location: Manchester, UK
|
Posted: Fri Jul 27, 2007 7:15 am Post subject: |
|
|
Passwords in most systems are stored using a one way hash. The password is encrypted and saved but can't ever be decrypted. When a user logs in the system encrypts the user input and compares that with the value stored in the database, if they are the same the passwords match. |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
genitus Tux's lil' helper
![Tux's lil' helper Tux's lil' helper](/images/ranks/rank_rect_1.gif)
Joined: 07 Jun 2007 Posts: 87 Location: Europe
|
Posted: Fri Jul 27, 2007 4:59 pm Post subject: |
|
|
ok thanks , everything is clear now ![Smile :)](images/smiles/icon_smile.gif) |
|
Back to top |
|
![](templates/gentoo/images/spacer.gif) |
|