Look at GRANT on mysql.com GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFITED BY '';
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Randall Perry [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 3:05 PM -->To: [EMAIL PROTECTED] -->Subject: Backing up all databases --> -->Am testing this command to backup databases: --> -->/usr/local/mysql/bin/mysqldump --opt --all-databases > -->/usr/local/mysql/data/mysqldump --> -->Am running as root, but it only backs up databases root has access too. --> -->What's the best way to handle this -- give root full perms on all dbs? --> --> -->-- -->Randall Perry -->sysTame --> -->Xserve Web Hosting/Co-location -->Website Development/Promotion -->Mac Consulting/Sales --> -->http://www.systame.com/ --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]