• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

How do I find the user's userids of mysql

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
marv
Just Arrived
Just Arrived


Joined: 15 Jun 2009
Posts: 0


Offline

PostPosted: Mon Jun 15, 2009 11:36 pm    Post subject: How do I find the user's userids of mysql Reply with quote

A client wanted me to create a web store using mysql, php, apache web server, and oscommerce. I have a windows PC, but it can run these. I was told on a forum that to make my life easier, I should go to a site called 'wampserver.com' where a program existed that downloads all of these (except for oscommerce). So I installed that program on my computer, and ran it. The problem is that "PHPMyAdmin" seems to rely on mysql, and its not recognizing the userid and password that I thought I had used for mysql.
So is there any way to get a list of userids (not passwords, just userids) of users registered for a database in mysql?
Also, has anyone heard of wampserver? I am wondering if it is a known product, because there is always a security risk of downloading software and running it based on the advice of some anonymous person on a forum.
Back to top
View user's profile Send private message
Groovicus
Trusted SF Member
Trusted SF Member


Joined: 19 May 2004
Posts: 9
Location: Centerville, South Dakota

Offline

PostPosted: Tue Jun 16, 2009 1:35 am    Post subject: Reply with quote

It seems sort of weird calling WAMP wampserver since the 'A' portion of the name stands for Apache, which is a web server. Anyway, I have used WAMP and XAMPP for both development and hosting, and they work great. Apache is the most popular open source web hosting package, and according to some websites, actually holds the largest global market share. Theoretically, since it is open source, there are many eyes on the source code which makes it more secure than any closed source solutions. MYSQL and PHP are also open source, and very well regarded.

If you do not have root access to the MYSQL database, then you can not really query any useful information at all. If you forgot the password or usename, you are going to have to uninstall MYSQL and reinstall it. When you set things up, did you add the password to the config.inc.php file? Maybe you should review the documentation here:
http://www.tinkertech.net/tutor/wamp/index.html
And see if you accidentally forgot anything.
Back to top
View user's profile Send private message Visit poster's website
capi
SF Senior Mod
SF Senior Mod


Joined: 21 Sep 2003
Posts: 16777097
Location: Portugal

Offline

PostPosted: Tue Jun 16, 2009 7:02 am    Post subject: Reply with quote

Groovicus wrote:
MYSQL [is] also open source, and very well regarded.

Very well regarded... hmm, if by MYSQL you mean PostgreSQL Wink
Back to top
View user's profile Send private message
stevenmour
Just Arrived
Just Arrived


Joined: 06 Oct 2010
Posts: 0


Offline

PostPosted: Mon Oct 11, 2010 1:51 pm    Post subject: my sql Reply with quote

If you are using php my admin then on adminpanel you can search any id with just typing in search box, if think this is very easy task
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
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

Community Area

Log in | Register