No Password
When I'm trying to access a database, MySql answer that
my access is denied for user root@localhost . For database ...
When I'm going in the users section of PhpMyAdmin, It said:
No user (s) found
What can I do, is there a manual way of adding user/password ???
View Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
Password :: Change Password
I have trixbox 1.2.3 running and in freePBX it told me I need to change the password in mysql. I went into mysqladmin and privileges. I updated the passwords for a2billinguser and root. Now I am denied from access to mysql and all services that use mysql don't work. How do I restore the default that trixbox used. I have a very large major system here and cannot just blow it away.
View Replies !
Password Set Up
I am trying to install MySQL Essential 4.1. on Windows ME and it will not let me set up a password. I have installed it on Windows 2000 before and it took me through several dialog boxes setting up a password. On Windows ME it already seems to have set up a password and kicks me out when I try running MySQL. Do I need to be connected to the Internet when Installing? Is there a difference installing on Windows ME.
View Replies !
Password?
I have installed MySql 4.1 on Windows XP (not as a service, manual start), but when I try to access the Command Line Client it asks me for a password and I have no idea what it is.
View Replies !
Getting A Password
I am trying to figure out how to get a password for a sql on my forums... My host provides where it installs the forums and just generates the sql stuff... Is there a way for me to figure out how to get the password?
View Replies !
Using Password: YES
I installed on my laptop MySql Server in Windows, and I've a problem login in with a simple user. With user root, it works ok, but when I try to coonnect with other user, I always obtaint the error message "using passowrd: YES" (MySQL error 1045). If I try to connect via command line with "mysql -u user" without indicating a password, it works ok, but if I try with "mysql -u user -p", when I enter the password, I have the error. If I tried to connect from MySqlAdministrator or QueryBrowser I have the same issue if I write the password, and a good connect without password.
View Replies !
How Do You Set A Password?
I entered in "set password for 'wikiuser'@'localhost'=password("password")" but it says it couldn't find any matching rows. But there is a row with that host and user. Also, there IS a password in the row, but when I try to install mediawiki, it says check username and password.
View Replies !
Having A Password
I want to be able to hold a password in my table in some kind of secure way. I have tried to insert a user record into a table using md5() for the password which is inserted in the database like this... insert into users values('', 'sim0rsy', md5('banana'), 'Matt', 'Munn', 'Student'); this is the query that I think should work but it doesnt, what am i missing? select * from users where username='sim0rsy' and password='banana';
View Replies !
Using Password NO
i keep getting this error i know iam useing the right password and i have set it to use old passwords? any idea's? Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:userdb.php on line 4 Warning: mysql_select_db(): Access denied for user 'ODBC'@'localhost' (using password: NO) in D:userdb.php on line 5 Warning: mysql_select_db(): A link to the server could not be established in D:userdb.php on line 5
View Replies !
Password()
we just moved our websites over to another datacenter and in the process noticing that we are having troubles logging into some of our sites. Just as a quick test I manually updated a test user's password to password=password('hello') but the funny thing is when I try to login with hello, no record found. I echo the query and paste it into mysql and it shows empty results. SO I then queried for it to show me the record for this user and it shows the encrypted password to start with an * and then all characters are CAPS. No matter what I update the password to, this is the case. All alpha chars are caps and the pass starts off with an *. Has anyone run into this before? All of this worked before and our data looks ok in our tables but if you update the pass, it screws it up bad.
View Replies !
Recover A Password
Is there a way to recover a lost password in Mysql 4.1. I have seen many articles and howto's on how to kill the Mysql process and then restart using skip grant tables option. I am not trying to reset the password but rather recover it. Resetting the password to something else would cause a problem some of the underlying programs that rely on MySQL. I don't feel like changing code for every application that is using MySQL in my site. Also along similar lines. What if I were to kill the MySQL process and then reload with the skip grant tables option and login to the MySQL server. Could I create another account with root priviledges, such as admin, while not messing with the original root account or it's password. Lastly is there a way to copy just the grant tables information to another copy of MySQL so that I can experiment with this process on a non production box?
View Replies !
Password In .my.cnf-file
Is it possible to use password in .my.cnf file automatically with function mysql_real_connection()? I mean so that it uses password mentioned in ini-file, so not to hard code it into program code, as mysql-client does. I am using version 4.1.9 for pc-linux-gnu (commercial version)
View Replies !
Mysqldump W/o Password
I have to run this to dump the database mysqldump -u root -pPASS --opt database > database.tmp Is there anyway I can hide the PASS is a file ? I was trying to put it in /root/.my.cnf as this [client] password = PASS That seems to be not working. I am not sure if mysqldump even reads that file. The only option worked for me is putting the password in a file /root/.pass and chmod it to 000 and then run this mysqldump -u root -p`cat /root/.pass` --opt database > database.tmp However I don't like this option because it tells you where the password is residing. I need to put this in cron so I don't like the option of showing the filename.
View Replies !
Set A Deault Password?
What do I do to set every possible user a default password? At the moment ppl can just log into mysql without providing any password if they just invent a user name.
View Replies !
User And Password
I just installed mysql for the 5th time... and I tried to follow the refrence manual on how to delete the default users that comes with it and add my own with a password so there is no annoynomis acess. But something happened and where it should of said mysql> It just had -> A arrow.. and I coldn't fix it, so can someone tell me how to delete all the users and make my own with a password. I can take it from there. I've been trying to set this up for a while cause i've been learning cold fusion, I just can't get this to work somehow.
View Replies !
ODBC W/ Password
I am using mysql 4.1.2 on a Win2K (SP3) host. I cannot seem to create a useable MyODBC DSN unless I set user=ODBC with no password. When I try to test a non-null password in the DSN configuration dialog for ODBC 3.51 I get the error message: "[MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client" This sounds like a server configuration issue but the client (presumably the ODBC driver in this case?) is being blamed, apparently. I have tried this on both MyODBC 3.51 and 2.50, getting nowhere.
View Replies !
Database Password
I was trying to install a mod that connects to my forum database and it prompted me for my database username password...and I can't remember it. Is there something I can do in cpanel or something to recover my password?
View Replies !
Copy Password
What is the correct method for copying the password for a user from mysql 4.0 to a 4.1 database? I know with 4.0 to 4.0 you can just use the same encrypted value, but I'm not sure when trying to setup the same user/password on 4.1 and not knowing the actual password.
View Replies !
Db Password Setup
I use phpMyAdmin to change db password, but failed. It says: SQL-query : SET PASSWORD = PASSWORD( '*******' ) MySQL said: You must have privileges to update tables in the mysql database to be able to change passwords for others
View Replies !
Empty Password
Does the mysql v4.1.7 allow empty passwords for the root user? cuz i noticed that without a password my program turns up a java.sql.Exception then access denied.
View Replies !
Password In Database
1- how to hide passwords to be shown by database administrator? 2- how to validate using SQL statement the typed password to the hidden password in database
View Replies !
Verify Password
A 'change password' screen in an application typically asks for the current password and the new password twice. I wanted to verify the current password before setting the new one, using: SELECT IF(password=PASSWORD('oldpass' ),1,0) as PWvalid FROM user WHERE user='myusername'; But the server hosting my database doesn't give you access to the mysql database, for obvious reasons. Is there a way to verify the current password without having to disconnect and reconnect?
View Replies !
Insert Password
I am doing a intsert statement where I want to insert some values including a encrypted password that I will be eventually used to login using a php script. I not sure how to insert the encrypted password part. Code: INSERT INTO users VALUES (1,'Head','Administrator',NULL,'admin','password_goes_here','ADMIN');
View Replies !
Change Password
I am borderline about to throw my computer out the window....I have installed, removed, installed again, removed again mysql 5.0 on my brand new Fedora 5 core with little success. I am logged in as root, and can get mysqld to start, however when I attempt to change my password by the following: mysql -u root I get the following message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
MySQL PASSWORD()
I have a field in my db that I assign a password() function so that when it is sent in from a browser form, i do "select userID, name, password from users where userID=$userID and password=password($password)"... this is just an example, but wondering what mysql uses to encrypt it.would it be better off to just use php's mcrypt or crypt myself? would that be more secure?
View Replies !
Setup Password
I have been trying to set up mysql on os x 10.4 tiger. Everything went well. I had a test php page. When I completed the setup of mysql I ran the test page and everything worked a treat . I had been following a tutorial, a wee bit out of date, but all good. It recommended that I give mysql a password like the root on the apple. So, I did: mysqladmin -u root password new_password_here It seemed to take it ok, i.e. didn't print an error message or anything. So, I thought all was well , but when I went back to the test page (after editing it and providing the new password details), I got an error : Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 5 Warning: mysql_select_db(): Access denied for user 'root'@'localhost' (using password: NO) in /Library/WebServer/Documents/test.php on line 9 Warning mysql_select_db(): A link to the server could not be established in /Library/WebServer/Documents/test.php on line 9 Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Password Access
I built a new MySQL DB, 5.x, been using 4.x. I moved DB's and user over and have not been having troubles. But now when I try to create a new user for a new DB I keep getting this error: access denied for user@localhost (using password: YES) I have read all the stickies, tried all the set to old password examples, deleted and recreated the user and DB, and still no success.Do all user have to use Old password technique if one uses it? Or can new users use the newer hash?Any other ideas of what I can check to fix this problem? I am going a bit nutty trying to figure it out.
View Replies !
Password Storage
I've been working on an update for an excisting site with 1000 or so users, my new version uses sha(password) to store the password in the database. I've just been handed the excel file of the old database and the password is stored in plaintext. Is it possible/easy to change all the plain text passwords into the encrypted sha() format? Is there another easy option? It would obviously be preferable for the old users to be able to log straight in with their old password.
View Replies !
Password() Vs Encode()
this is a pretty basic question. I was wondering which would be better for a password field, password() or encode(). My one concern is that if I use the password() function and cant view the actual password ever again how would I be able to email a user their password if they froget it.
View Replies !
Password Cannot Login
I had problems in one of my user's account, I used phpMyAdmin to edit this user and changed his password. Whatever I change his password, he just cannot login, even very simple password such as "1" can't do the work... When I remove the password, he can login normally. I have checked the password field on the mysql table which is long enough to hold the full encrypted password, although I noticed an asterisk * was put at the beginning of the encrypted password, which was not found on other accounts I had a similar problem before and then I noticed my "username" and "password" field is too short to hold the whole username information, I fixed it by increasing the field length. I don't know why that happens... Migration from non-unicode to unicode database perhaps? Or being hacked in?
View Replies !
Reconfiguring Password
I have a problem with connecting to MySQL via the command line client. When I start my machine and the client it asks for my password, which doesnt work. I need to reconfigure MySQL using the configuration wizard every time. Then I can connect to MySQL as root normally.
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
My 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: $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 !
Password:: Setup
I have screwed up my password somehow. I have just started using MySQL and downloaded the Administrator. Also trying to use Dreamweaver and following their instructions tried to use the Administrator to set up a user with no name. NOw when I try to set mySQL it asks for my password which apparently is invalid (computer beeps). Now I cannot use mySQL. How do I recover from this?
View Replies !
Password :: Newpwd
After the installation in windows xp, I write in DOS mysqladmin -u root -p password newpwd; but the answer is: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (Using password: NO)' How can I do? If I use the istance configuration wizard, I have error when, after the new password, I start execute: Could not start the service MySQL. Error:0
View Replies !
Forget Password
I have installed MAXDB ( Database Manager 7.6 ) into my machine. Unfortunately I forgot password which I used uring installation. Is there any way by which I can retrieve my password,please let me know. Otherwise I will have to reinsatll the whole software .
View Replies !
Password Seems To Reset
It seems that the password for the root user account becomes invalid after each reboot of my operating system (Windows XP) I have to skip the the grant tables and reset the password each time. I would like to know why this is occurring and what I can do to safeguard future lockouts. I have not been able to determine if it is being accessed by someone else who is changing the root password.
View Replies !
Password Request
I just recently downloaded the community version of MySQL 5.0. I'm trying to set it up using the Config wizard. A while ago I asked how I go about getting or finding out what my root password is so I can proceed with the set up. I was told to set up my password using the command line.I was also told to log in as root and issue the command SET PASSWORD ('[new password]'); When I open Command line it automatically asks for my password. Since I don't have one yet I tried to ignore the request by typing the info. above and it won't let me in. Is there another way for me to set up my password using command line? I also don't understand how to log in as root.
View Replies !
How To Encrypt Password
currently using mysql with c# coding. I need to know how do i encrypt password so that it will not show the password in plain text when i access the database.
View Replies !
Old 'root' Password
I'm trying to install MySQL server 5.1 on Windows and I'm getting error # 2003. It seems that I have a previous installation (which I must have forgotten) which I uninstalled but the old root password is still in the data dir which was not removed in the uninstall and I require it to create a new one. How do I - a) remove the old one or b) discover the old password so I can reuse it ??
View Replies !
Cannot Set MySQL Password On My Mac
I had an old version of MySql on my Mac. I recently installed the latest version of MySql. I tried to set a password in terminal using the steps shown below, but I get the error message shown below. I don't remember the password for my previous MySQL installation. Welcome to Darwin! localhost:~ helpprob% alias mysql=/usr/local/mysql/bin/mysql localhost:~ helpprob% mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I have also tried: mysqladmin -password <new password> and the same command without the dash before "password." I have also tried searching the MySQL manual and have tried various things that I thought it was recommending, to no avail. In some variations of what I have tried, I get the same error message except the end reads, "password: YES)
View Replies !
Used Wrong Password
I installed MySQL through XAMPP application to Windows XP SP2. All was well, I opened the ADMIN of MySQL from the XAMPP Control Panel and received a drop down box asking for user name and password. For username I used my own name. I have since found out that I should have used "root".I went through a whole bunch of problems with "access violation messages which are still coming, although now I know how to shut them off, but I cannot access MySQL at all to change the password to what it was supposed to be.In essence, I cannot use it at all, and I don't know how to make the fix. Could someone please advise?
View Replies !
|
TRACKER
