0
votes
1answer
42 views

Ubuntu 12.04 LTS: Changing Mysql root Password

I did an upgrade from 10.04 to 12.04 today. I wanted to access MySQL afterwards, but I've forgot the root password... So I tried some guides from the net but none is working for me. Im not even sure ...
1
vote
1answer
81 views

Puppet random password generating

I am going to install around 100 mysql servers and I would like to have different root password on every of them. I am going to use puppet mysql (https://forge.puppetlabs.com/puppetlabs/mysql) which ...
0
votes
1answer
37 views

I changed mysql root password and I cant access It. password contained some chars

using this command I changed root password mysqladmin -u root password fg$pkh@567fghu And now I cant access mysql. Is this because mysql parse the chars other than what I expect? Also I ...
0
votes
0answers
32 views

ProFTPd mod_sftp mod_sftp_sql

I am working on Ubuntu 12.04 I have setup a ProFTPd service with SSL/TLS, virtual users stored in a MySQL database and quota (mod_tls, mod_sql, mod_sql_mysql, mod_quotatab, mod_quotatab_sql). It works ...
0
votes
2answers
60 views

MySQL - Does the change in MySQL master db password affect on slave db?

I want to change the MySQL DB password on the master db. My question is: do we have to care for the slave DB when changing the master database password?
0
votes
0answers
147 views

Where does ISPConfig store the MySQL credentials?

I need to know where ISPConfig keeps the rest of its MySQL credentials So, we reset the root MySQL password, and ever since, whenever I try to install wordpress via ISPConfig , it gives me ...
0
votes
2answers
1k views

Allow linux root user mysql root access without password

On cPanel when I am logged in as root and type "mysql" without hostname and password it gives me direct access to mysql root user. I would like to do this for one of my non-cpanel server where the ...
-1
votes
1answer
28 views

Forgot MySQL password

Today I realized that I forgot the MySQL password, or that somebody else changed it (I doubt it). Is there any possibility that I can get the root password? I have access to all the machine (as it's ...
0
votes
2answers
279 views

MySQL without password prompt?

I have a MySQL server with the MySQL root password is an empty string. If I try to connect to MySQL without a password, I am denied. Like this: # mysql ERROR 1045 (28000): Access denied for user ...
0
votes
0answers
186 views

Passwords imported from SQLite to MySQL don't work

When importing an SQLite database into MySQL I have repeatedly encountered the problem that encrypted passwords (even when copied manually) do not work anymore. Everything else works fine, but all ...
2
votes
1answer
319 views

Pure FTPd and MySQL, working with sha512

I'm currently developing an application for shared hosting, using a complete MySQL backend for the machine. I've set up all my services, and they're quite operational, however I've a little problem ...
0
votes
1answer
952 views

Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

We have installed PHPMyAdmin on a windows machine running IIS 7.0. We are able to connect to MySQL using command-line, But we are not able to connect using PHPMyAdmin. The error displayed is: Error ...
-2
votes
1answer
111 views

Mysql on ubuntu root password dissapeared somehow? Password no more required for mysql root? [duplicate]

Possible Duplicate: Mysql loses its root password I am sure i have mysql server installed on localhost with ubuntu with root user and required password. I have continued my daily developing ...
1
vote
3answers
126 views

Reset and then restore mysql password

I have linux root password. There's MySQL server on that machine. One of the site's ini was rewritten and now it can't reach the mysql database. I don't have mysql root to change the password for ...
0
votes
1answer
447 views

Cannot connect to mySQL because of invalid settings

I'm new to xampp, and have it installed on a Windows 7 machine. Earlier, I was able to at least get the login page for phpMyAdmin, but it was not taking username of "root" and no password, so I ...
1
vote
0answers
830 views

Log in successful in MySQL but fail in phpMyAdmin

I'm having a problem with my MySQL / phpMyAdmin couple. I can log in MySQL but when I try to log in phpMyAdmin the error returned is "#2000 Cannot log in to the MySQL Server" . I'm running Windows ...
1
vote
3answers
302 views

MySQL wants a password but it's empty

mysql -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) mysql -uroot -p Enter password: <-- leave blank, hit enter without entering anything ...
0
votes
1answer
708 views

Install mysql-server and set password from the command line?

I am installing MySQL via the command line: sudo apt-get install mysql-server. During the installation process, it prompts me for a root password. How can I specify the MySQL password without having ...
2
votes
2answers
471 views

Reset mysql root password after phpmyadmin corrupted it [duplicate]

So I tried to change my mysql root password for the first time using a advanced pattern and it looks like phpmyadmin stripped the password on save. Now I can't login under root. I am using RHEL 5 ...
2
votes
1answer
65 views

MySQL stopped asking for passwords

I'm currently experiencing a weird problem with one of my MySQL database servers: It stopped asking for passwords when I try to access the database from local with the mysql command line tool. I ...
0
votes
2answers
144 views

Cannot log into mysql after invoking mysql from shell script

(My first question here, so if I am flouting any conventions, I apologize in advance!) This is my first attempt at creating a shell script. I am trying to create new databases and users and passwords ...
3
votes
1answer
176 views

When I am root, “mysql” connects without a password, even though I've set one

When I am root, "mysql" connects without a password, even though I've set one: # mysqladmin -u root password 'whatever' # mysql -u root -p Enter password: (typing the 'whatever' above) Welcome to the ...
0
votes
4answers
367 views

Safety concerns on allowing connections to MySQL with no password on localhost?

In the case of a Linux system, is there any security concern to let MySQL users with standard privileges (that is, not the root users) connect to the database with no password from localhost? I think ...
2
votes
2answers
3k views

How to make phpMyAdmin ask for my username and password

I am using rhel 5 and php 5 with mysql 5. My server is already configured and running all applications smoothly. I am accessing mysql as root and supplying my password. However, when I access ...
1
vote
1answer
459 views

how to restore access to MySQL after deleting all privileges?

Ok, I know I'm stupid. I deleted all privileges to MySQL, I have access to root account on host. Is there any way to add account to mysql?
0
votes
1answer
6k views

How to set password for phpMyAdmin with default install of WAMP2?

I just installed it fresh, previously there would be no password at all and I'd be prompted to set one for security purposes, this time I'm just hit with an error: "Cannot connect: invalid ...
1
vote
1answer
1k views

Upgrading PHP, MySQL old-passwords issue

I've inherited a Windows 2k3 server running an XAMPP-installation from the stone age. I needed to upgrade PHP to facilitate an upgrade to MediaWiki to facilitate a new MediaWiki extension (to ...
19
votes
16answers
1k views

Why is it bad to have a weak mysql user password?

I was presented with an argument to the tune of "you don't need a strong mysql user password because in order to use it, they'd already have access to your server." We're talking about a 4 digit ...
1
vote
2answers
1k views

Change password of PhpMyAdmin on localhost

I have upgraded Ubuntu 9.10 to Ubuntu 10.10 but I cannot access PhpMyAdmin. How can I change the username and password for PhpMyAdmin? I urgently need to access PhpMyaAmin because my database is ...
1
vote
2answers
315 views

Unable to set the password in My SQL

I installed wamp in my windows 7 machine. While setting the root password in mysql , I got following error : C:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root ERROR 1045 (28000): Access denied for ...
1
vote
2answers
716 views

MySQL: Permit user to change his/her _own_ password

On a webserver there is a MySQL-service running, providing databases for the users of the server. Each user has it's own DB and it's own password and the right so INSERT/SELECT/UPDATE/DROP tables in ...
18
votes
14answers
2k views

Should I force my users to change passwords every n days/weeks/month?

Question says it all. We are designing a system where security is very important. One of the ideas someone had was to force users to change passwords every 3 months. My take on this is that while its ...
1
vote
2answers
116 views
3
votes
2answers
927 views

Escaping a password using mysqldump console

I am running a mysqldump via a bash script and have encountered a problem with a password that contains special characters. mysqldump -hlocalhost -uUSERNAME -pPA$$W0RD DATABASE | ...
0
votes
1answer
843 views

Plesk admin password for MySQL

Does anyone know how Plesk stores MySQL admin password? I accidentally changed the admin password in MySQL's user table which was set by Plesk and now Plesk is broken.
0
votes
3answers
95 views

Accessing a remote MySQL host with a hard-coded password

How to write a bash command for accessing a remote MySQL server? If I try mysql -host 10.1.1.20 -port 3306 -u root -p 1234 it prompts the password and after I type in the password it considers ...
0
votes
3answers
1k views

Start MySQL 4.1 without “old-passwords”

I am having a hard time migrating my MySQL 4.1 database from old 16-byte password hashes to the new 41-byte hashes. The problem is, that the mysqld server automatically starts with the "old-passwords ...
0
votes
2answers
2k views

where are MySQL password hashes and databases stored

In what file does mysql store the password hashes and the databases on a linux system? I know that mysql users/hashes are stored in mysql.user, but what file is that? What are the default permissions ...
2
votes
5answers
664 views

What is my MySQL root password?

Where or how do I check MySQL root password? I don't have a .my.cnf file, I can't login to SQL console (it requires a password), I can't do anything.
1
vote
2answers
6k views

Reset MySQL 5 root password on Mac OS X

I just installed MySQL 5 on Mac OS X Snow Leopard (10.6.1), set a password and forgot it. I tried to follow this tutorial: ...
2
votes
2answers
308 views

How do I set up Apache HTTP authorization with a salt in my password?

I'm using mod_auth_mysql with Apache 2 and MySQL 5 for apache authorization. Right now our passwords are being stored in the plain in our database. As a new requirement, we have to store them with a ...
10
votes
4answers
3k views

How to reset or recover admin account password for MySQL?

I have a MySQL database that I "inherited" and I was not given the admin credentials. I do however have access to the box that it runs on. Is there a way to either recover the admin credentials or ...