LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 06-22-2003, 05:27 AM   #1
LammaDog
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
Troy
 
Old 06-22-2003, 05:57 AM   #2
LammaDog
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.
 
  


Reply


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 04:46 PM
deleting users from mysql jsheffie Linux - Software 4 10-18-2005 10:29 PM
Can I place mysql dbs in a folder that I define macmichael01 Suse/Novell 5 06-28-2005 02:35 PM
can't add users to mysql niehls Linux - Software 2 02-21-2003 06:33 AM
MySQL ~users santiagodelgado Linux - Networking 1 11-30-2001 09:58 AM


All times are GMT -5. The time now is 12:16 AM.

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