Lost Phpmyadmin Password, Can't Do Backups!
I'm trying to run a backup on a bitrock install sugarcrm on linux.
apache is running on port 8888, i try to get into phpmyadmin but it
asks for user and password.
I don't know what the user/password is. I saw user file so i know user
= administrator. but I don't know password.
I have access to the httpd.conf file. I see the last part of the file
concerns authentication for phpmyadmin. Is there a way to turn off
authentication? I just need to get a backup.
I also try to use the command line but i get error 2202. it can't read
the /tmp/mysql.sock file.
i know mysql works because sugarcrm works fine from a browser.
View Complete Forum Thread with Replies
Related Forum Messages:
Lost Password To Connect
I dont remember at all what was the password when installing Mysql 5 now when i try to connect with mysql administrator i cannot come in i am using windows xp prp where can i find my password ?
View Replies !
Root Password Lost
I am an Oracle DBA and new to MySQL. I have to do some urgent work on MySQL but problem is that I have been assigned a user/password which does not have access to grants tables (mysql schema). My user has access to only one database, and is allowed to connect only from the same machine which hosts the database (which is on linux). So, I am not able to connect to database from my Windows machine having GUI database client tools. The actual DBA of the system who had root password has gone and now nobody knows the mysql's root user password. I wanted my user to be able to connect remotely which requires changes in grant tables, but only root user can grant this priviledge. Can someone please help me? how can i get the priviledges that only root can grant? is there a way to know root password or, to reset root's password? plz help.
View Replies !
Lost Password For MySQL Table....
I need the DBPASS for one of my MySQL databases. Unfortunatly I made it a while ago and never thought i would need to know the password. Im not sure what the password is.... Ive got two options: 1. find out the old password 2. reset the password to another password but the problem is then i need to tell the forum (invision power board) that the password has changed. If anyone knows how to change the DBPASS on invision power board,
View Replies !
Lost Password Black Hole
Is it possible to gain access to a MySql db without the password. Yeah i know sounds like i am hacking into something i shouldn't be. Rather it is the colmanation of some less than perfect management tequnics that have left passwords and usernames disapearing with former employees.
View Replies !
Lost 'mysql Root' Password
I logged in as root successfully and created a user with access to a certain database. I could not do all i expected to with my new user so I tried to login as root again and now I cannot login with my old password, new users password, etc. Only my own development box, so no great catastrophe however I do need to login as root. Can anyone give me a way to change my mysql root password? or point me to site that does?
View Replies !
Lost Username And Password To MySQL Server....
I have been using the MySQL control center and had my usernames and passwords for the MySQL server stored in the control center. I recently lost everything on my PC including the usernames and passwords. Does anyone know if there is a way to reset or remove the passwords from MySQL so that I can make new ones? I do have the root password for the server that MySQL is running on.
View Replies !
Have To Set Password In Phpmyadmin
I am using php4 and mysql and running them in IIS. I installed all in C:. Then I put phpmyadmin folder into the wwwroot folder. When I login http://www.mysite/phpmyadmin then it display the login page of username & password. If I keep blank those 2 fields it just direct enter to the "welcome page" of the phpmyadmin & doesn't show any option to change password or other option of the mysql. So the problem is any one can login directly to the database of the mysite. Please tell me what should I do??? Is it for mysql setup (its userid & password), or php setup or itegration os there version or something else?
View Replies !
PhpMyAdmin :: Root Password
I have given root a password in MySQL, but now phpMyAdmin says "access denied". I've put the following line in config.sample.inc.php: Code: $cfg['Servers'][$i]['password'] = 'password_goes_here'; but it doesn't seem to make any difference. How do I get phpMyAdmin to recognise my root password?
View Replies !
PhpMyAdmin :: Default Password?
I have just installed PHPMyAdmin on my SUSE 10.2 PC. When I address it in my browser I get the login but I do not know what the default pwd is. I have tried Root+<rootLogin> and blanks buit each time I get a blank screen.
View Replies !
Username And Password For Phpmyadmin
I have to put a password and username for that php page where is index for phpmyadmin, my site is on some german windows server, which is user-nofriendly, no support, so these guys can not help me. I tryed with http auth or cookies, its not working, only config (which is without password. If i use http authentification, i allways have a small window for user and pass, but if i write a proper user/pass it pop up again, like its not a good pass or user.
View Replies !
Implement Password On Phpmyadmin
we all work in a network environment. we all can access phpmyadmin of any other. is it possible to implement password on it. i want if anybody try to access my phpmyadmin e.g.(aamir/phpmyadmin, aamir is my system name), a dialogue box of password will come. if he enters the right password, he can access that.
View Replies !
How To Create User And Password In Phpmyadmin
I built a couple of databases on my new localhost for Joomla, and did not specify uesrname and password, and guess what? I know about the security issue, but worse than that, installation cannot continue until I can figure out how to create username and password, either in a sql window, or mysql console,
View Replies !
PhpMyAdmin :: Password In Config.inc.php Not Working
I have had it running on here before, and used it lots, but have been in a hiatus from computing for some time, and am back at it agiain, but when I tried to access my test site or databases with phpMyAdmin, it simply wouldn't work for me, so I reinstalled mysql and phpMyAdmin. I can access mysql as root via command line, but when I enter the user root and password in the config.inc.php file, then try to log on to phpMyAdmin, it does not let me in, the password box just keeps re-appearing. I have followed the instructions very specifically a number of times now and still nothing. Anyidea on what dumb mistake I am making?? in the mean time, back to the command line... sigh
View Replies !
Password/Username Locked Me Out Of PhpMyAdmin
I'm using MySQL 5.X on a Mac. I was trying to create a password and username for a new database. I created the database, then clicked on Privileges. Next, I created a password and username. Not only can I not access the database, I can't even access phpMyAdmin now; I get this error message:
View Replies !
Scheduled Backups
I am not familiar with backing up mysql. I understand the mysqldump tool can be used with php somehow and also that there are several free tools available.
View Replies !
Creating Backups
I have designed a peice of code in 2 dif prog langs which create backups of the same database. However both take a fair old while to run because it goes through line by line of each table to create the backup. I have 2 servers: First is where all the live data sits and the second stores all my archived / backup data. Is there any way in SQL to actually copy from one server to another the complete database without human intervention. This probably is a really simple question but i haven't really looked down the path of using just SQL to do it?
View Replies !
Rolling Backups
I currently have windows task scheduler set up to run a batch file that runs mysqldump, to backup all of my local databases, it looks a bit like this: mysqldump --user=root --password=password --all-databases > "d:ackupsdump.sql" I want to modify so that the file name of the backup is based on todays date, and then get it to automatically delete the oldest backup file, so that I always have the last 5 days of backups.
View Replies !
Backups & Best Practices
I have just been told that I am responsible for Administering a MySQL install. I am an experienced SQL Server Admin and have an idea what needs to be set up, Backups for one thing). I plan to use the MySQL Administrator GUI. I'm looking for Best Practices in General and for backups in particular. The databases ar MyISAM. Any help would be appreciated. MySQL version is 4.1.15-nt client version is 5.0.11 Administrator version is 1.1.5
View Replies !
Automatic DB Backups
I've been looking at a way to backup my DB automatically (say, every day). All I found was this backup (http://members.lycos.co.uk/wipe_out/automysqlbackup/) but I have to idea how this works, especially these 2 lines - Make the file executable :- chmod u+rwx - Every day AutoMySQLBackup will run (if setup on /etc/cron.daily).
View Replies !
InnoDB Weekly Backups
We need to implement a backup solution for our innodb tables (~50gigs) that: 1) Runs automatically, weekly, and in the background w/o interrupting normal usage 2) Is capable of restoring individual tables 3) Can backup across networked computers I've searched and found a few options: InnoDB Hot Backup ($510/year), PeerSync ($899/perp), and Servosity Remote data backup (~$350/month). Does anyone have any experiences or suggestions about other solutions or the ones above?
View Replies !
Full Server Backups
Am i right in assuming that if I copy my C:/.../mysql/data direcotry and if my entire server crashed, I reinstall mysql. and drop the oringal /data direcotry into the new installtion /data direcotry, will everything work out ok? Anyone have any other methods of backing up an entire MySQL server? Is there a program that can make a query that will authomatically create the databases, and do it in one file?
View Replies !
MySQL Database Backups
I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of database backing is to do it manually. I navigate to the mysql data directory, and copy and then paste it onto a CD of mine. I hate how I have to manually do this all the time. I tried Windows scheduled task manager to create a backup of the mysql data directory but its a no go. Somehow it always fails when trying to back it up
View Replies !
Scheduled Backups Not Happening
I am running 5.0.19 on a win2k server and for some reason the sheduled backups just dont seem to happen. If i try to manually initiate the job "execute backup now" it works fine but scheduling it doesnt seem to do anything?
View Replies !
Doing Internal Data Backups
We have managed server backups in case of server error. We also do four daily mySQL dumps using a Linux Script which simply dumps the mySQL database to a file whos name is the date and time. This was, if we ever accidentally delete data we can retrieve it. This is not in case of server error (as the backups are stored within the server itself anyway). These are data backups so that we have an ongoing backup of data in the mySQL. The trouble is that each backup is taking 150mb because file attachments are stored in the database. This seems silly as most of the data is in fact the same.
View Replies !
Importing Large Backups
I have a 600 MB .sql dump which I got from someone. I need to import that .sql file to my database. PHPmyadmin does not allow that big files to import. The desktop based mysql client (SQLYog) which I am using to manage MySQL databases, also crashes while importing. I am on a windows system. Could you please suggest me a better and effective way to import it?
View Replies !
Backups Of Raw Db Files - Indexes Needed?
Right now I am backing up mysql 4.0.14 on Windows 2000 with a scheduled batch file that shuts down the mysql service - copies the entire data directory to a backup directory, and restarts the mysql service. this ackup directory then goes onto tape a couple of hours later via veritas remote backup agent. I have tested a restore of this backup method and it works fine. Now I would like to add some more indexes to a table that has 11 million rows, however the index files will be very large. Is it necessary to backup index files? In case a restore was needed, I could just recreate the indexes manually (via a batch file with the correct index commands). Will mysql choke if the table definition shows an index - but the index file is missing? are there any "bad things" that will happen if index files are missing?
View Replies !
Creating Backups From Shell Scripts
I am thinking of using the shell script mentioned here to take daily backups. I have added the --opt option to the mysqldump command. Is it essential to have a separate user for the backup process? Binary logging is disabled. Any precautions that I need to take?
View Replies !
MySQL Admin Scheduled Backups
Two problems: 1.-- MySQL Administrator will do backups manually and for sometime it did scheduled backups, as well. Now a scheduled job will fail and generate an event id 1000 error: Faulting application MySQLAdministrator.exe, version 1.2.3.0, faulting module MySQLAdministrator.exe, version 1.2.3.0, fault address 0x001e5342. 2.-- The SQL error logs have disappeared since starting the use of Administrator for backups. Is there a way to get them back or at least start the recording again? The only thing that ever showed up in the logs was the shut down and start up of the MySQL service at the beginning and end of a flat file backup of the entire database. Still... it would nice to have the logs back.
View Replies !
MySQL Admin Backups Won't Work
I’m using MySQL Administrator and MySQL Query Browser and want to make a backup of a database. First you click on the “New Project” button and name the project. Next the documentation for MySQL Administrator says… “To choose the databases and tables that will be backed up, select the database from the schemata list and click the > button. Once the database is in the Backup Content list, you can un-check specific tables that you do not wish to back up. “ That sounds straight forward enough – it works like every other gui out there. The problem is you click on the database you want to backup and it doesn’t become highlighted and when you click on the”>” button, nothing happens. Why?
View Replies !
Backups Taken By Mysqldump Locks Database
i've made a backup / restore script which first dumps the content of the database with mysqldump and the copies the backup file to another location. What i find strange is that after mysqldump is finished with dumping the data and the copy operation is started, the database does not accept inserts or update. In our Java application (using hibernate) we are informed that tables are locked (even thoug they should not be). when the copy process is finished it works again!
View Replies !
MYSQL ADMINOSTRATOR And Scheduled Backups
anyone use the MYSQL ADMINISTRATOR programs (in win xp platform) and actually have the SCHEDULED backups to work? i can create a scheduled backup and hit the BACKUP NOW to do a manual one, but the auto scheduling one doesnt work. i installed their latest version and still nothing...
View Replies !
Restoring Backups From WindowsXP To Linux Ubuntu
I have MySQL tables on a WindowsXP box and backed them up then tried to restore them onto a Linux box. However, it doesn't seem to work. I can find no trace of the restored files (there are no errors) on the Linux box even though the restore process displays as if it's taking place normally and successfully Any suggestions?
View Replies !
Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords. I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.
View Replies !
Incremental Backups Using Update Logs With Multiple Databases
I've set up my server to keep update logs for incremental backups, as described in Kevin Yank's book (Build Your Own... 3rd Edition), but I've noticed that the update.* files have entries from all the databases on my server. Is there a way to automatically split up the log files so that I can have separate update.* files for each database?
View Replies !
Auto-backup Database - Delete Backups Older Than X Days
I am not planning on doing this yet but I need to know from a feasibility point of view. I know it is possible to set up cron jobs to automatically backup databases on whatever time cycle you want but I have no experience writing them. Does anyone know how you tell it to backup your database with a name and a timestamp, while also deleting backups older than x (7 for example) days? Also does anyone know how to keep backups secure online? Do you encrypt them? Do you download them to a local server? To your own computer (unless its a very large database)? How do people practically go about making sure backups work, and secure them effectively. And if you do download them to your own local computer, how do you go about doing that? Is it an automatic thing? I just have all these questions but I have no idea about going about performing backups the most efficient and secure way!
View Replies !
Mysql Password() & Unix Crypt Password...
I am creating a user administration system where system administrator can activate services for a user, like webspace, a mail account or a subdomain. I now want to create a function that creates mysql databases and grant the right privileges to a user. But the problem is that mysql wants to have the plaintext password for the user in the "grant ... identified by 'pwd'" field, or in a manual query to update the password in the mysql.user table with PASSWORD('pwd'). I have another database which holds the passwords for the users, these password are stored the moment a user signs up and are used to activate services, for example ssh access to the machine. The stored passwords are encrypted using crypt(). So for adding a ssh service to a user, I simply do echo "$user:$pwdhash" | chpasswd -e. I have chosen crypt because some programs (like proftpd) don't take md5 sums. The problems is that I don't have the plaintext password. So I cannot add a mysql db. So I need to create a user in mysql with a crypt password. I tried to just "grant all privileges ... identified by 'nothing'" and then afterwards update the mysql.user table and putt the crypt password in there but it doesn't work like that. Does anyone have any idea on how I could fix this, how can I create a user in mysql without having his plaintext password and only having a crypt hash of it. I thought about not only storing a crypt hash, but also an md5 hash and a mysql PASSWORD() hash.. but I think that's an ugly solution.
View Replies !
I Can Connect With Db Password Or Blank Password
I have a password setup for root (% and localhost) in Mysql 5.0.26, I can connect ok no problem. I can also connect with blank password! I know it is checking the password cuz it fails if it's wrong. I'm sure I have only one account as well (tried to delete, recreate, etc... no change) select * from user where user='root'; | localhost | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... | % | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... Is there an option to accept blank password!? I have this problem only for root user; Other accounts are fine.
View Replies !
|
TRACKER
