Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[solved]list existing mySQL accounts ?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
genitus
Tux's lil' helper
Tux's lil' helper


Joined: 07 Jun 2007
Posts: 87
Location: Europe

PostPosted: Thu Jul 26, 2007 9:24 pm    Post subject: [solved]list existing mySQL accounts ? Reply with quote

i couldn't find that fast enough , seems like that question is not answered where it should be :evil: .
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
View user's profile Send private message
elgato319
Guru
Guru


Joined: 15 Sep 2005
Posts: 546

PostPosted: Thu Jul 26, 2007 9:44 pm    Post subject: Reply with quote

Code:

mysql -h 127.0.0.1 -u root -p

use mysql;
select * from user;
select * from db;
Back to top
View user's profile Send private message
genitus
Tux's lil' helper
Tux's lil' helper


Joined: 07 Jun 2007
Posts: 87
Location: Europe

PostPosted: Fri Jul 27, 2007 12:31 am    Post subject: Reply with quote

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
View user's profile Send private message
elgato319
Guru
Guru


Joined: 15 Sep 2005
Posts: 546

PostPosted: Fri Jul 27, 2007 6:53 am    Post subject: Reply with quote

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
View user's profile Send private message
nobspangle
Veteran
Veteran


Joined: 23 Mar 2004
Posts: 1318
Location: Manchester, UK

PostPosted: Fri Jul 27, 2007 7:15 am    Post subject: Reply with quote

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
View user's profile Send private message
genitus
Tux's lil' helper
Tux's lil' helper


Joined: 07 Jun 2007
Posts: 87
Location: Europe

PostPosted: Fri Jul 27, 2007 4:59 pm    Post subject: Reply with quote

ok thanks , everything is clear now :)
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum