Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 06-22-2003, 04:27 AM   #1
LQ Newbie
Registered: Sep 2001
Location: Colorful Colorado
Posts: 8

Rep: Reputation: 0
MySQL - matchings users to dbs?

Hey Guyz,

I'm putting together a new backup script, that stores the daily backups in the user directorys (sorta like Cpanel does it) But I also want to backup the users databases there too.

The problem I'm having, is that I don't know which database is owned by which user. And I'm afraid to experiment with the Grant tables on the live server. (I'm getting ready to move, and my test box is packed away)

Can someone please give me the command to query who owns a particular mysql database?

Thanks in Advance
Old 06-22-2003, 04:57 AM   #2
LQ Newbie
Registered: Sep 2001
Location: Colorful Colorado
Posts: 8

Original Poster
Rep: Reputation: 0
oh ok, I got it. that was way too easy

I just had to 'use mysql' and it was all right there for me.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting and reusing existing mysql permissions/dbs/tables after update deesto *BSD 0 10-29-2005 03:46 PM
deleting users from mysql jsheffie Linux - Software 4 10-18-2005 09:29 PM
Can I place mysql dbs in a folder that I define macmichael01 SUSE / openSUSE 5 06-28-2005 01:35 PM
can't add users to mysql niehls Linux - Software 2 02-21-2003 05:33 AM
MySQL ~users santiagodelgado Linux - Networking 1 11-30-2001 08:58 AM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 02:28 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration