Setting Password & Salt Then Cannot Login
I go into "phpmyadmin" mysql admin gui and set a passwd and salt for an account .....
i enter username as <usernametext> ... that is plaintext
i enter passwd as sha1(<passwdtext>) so it displays in table encrypted
i enter salt as <salttext> .... that is plaintext
now below is authen logic for login .....
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 !
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 !
Password Login
i have a simple java code for a password login but it only allows one user name and password, do i need mysql to have more users and i also want a registration page.
View Replies !
Login Password Problem
I am running Mac OS X 10.4 (PPC) I have installed MySQL server and have the use account mysql but I have no idea of the password. When the install ran it did not give me the opportunity to set a password and I can not find anywhere that states a default password.
View Replies !
Login / Password Encryption
i am trying to create a very simple login system. all it does it input user data including a password and then when logging it it compares user name and password entered to find the user id (if exists) and then says you are logged in if a result was found. my problem is no results are ever found. i have found that no matter what i do the password() function never returns the same value when im trying to select a user id with password=password('$inputedpassword') in the query to look up the user id. so basically when i register the password is turned into a mess with password(), but wheni log in and use the same password() on it, it gives me something different. BUT if i register under another user name and then use the same password, password() will give me the same mess (i checked this in the databse). so i dont know why password() wont do the same thing when im using it in the query in login.php so that i can compare the passwords correctly. the only way i've been able to get this to login is to not encrypt anything. i have tried using md5 but that is giving me this same problem too. Code:
View Replies !
Root Password :: Cannot Login To Mysql
i am new to mysql.i have installed mysql software which is provided with Linux CD .i need to provide password to root.i updated the user table to give password to the root.after restarting the mysqld service , i couldnt enter into mysql .one error message is displaying ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View Replies !
User Not Needing Password For Login?
I've seen this problem for a while now, but since at the time I only needed 1 MySQL user for development purposes it wasn't a problem. Now, it's problematic. Btw, I have MySQL 5.0.22 installed. I created a user using the following command (I've tried this way and using GRANT): INSERT INTO user VALUES('%','XXXX',PASSWORD('YYYYY'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', '','','','',0,0,0,0); Now, I see that row in the mysql.user table. I see the encrypted password, BUT when I try to log in to mysql from the command prompt using the user that I just created... it NEVER needs the password (YYYYY) that I set it to in the INSERT. >> mysql -uXXXX ^ That command takes me straight to the mysql command prompt. I am wanting the command to have to be 'mysql -uXXXX -p'... and then prompt for the password. Am I missing something?
View Replies !
Login :: File To Read For Username And Password
What file is read for username and password, i know in the wizard you set this up but what file is read with the userames and passwords? Ok i was reading that i can access the database via web interface i tried http://localhost:3307 but nothing ....
View Replies !
Setting Password
I successfully added MySQL, setup db's and did initial app development. I did all of this under the root user and blank password. When I ported the new development to the web site I tried to setup a user and password for the application and set the root password and ran into a brick wall. I am now locked out MySQL in terminal mode, phpAdmin will not save a config, MySQL GUI Admin will not save passwords and under options it says it cannot locate the /etc/my.cnf file. I have looked at a number of tutorials to set up the my.cnf file and they seem to conflict with one another and have been reticent to take action to make sure I was going in the correct direction. I am using QS10.4, phpAdmin 2.11, MySql 5.05, GUI Tools for 5.0. Can anyone point me the right direction to line up all of the security related files to get control back, successfully run the app on the local environment and and continue development.
View Replies !
Salt
What is salting?I get the basics of password dealing. In inserts like registration, encrypt the password with the standard password('blah'); function and then the things like making the mysql field for pw 16 char long but limiting the form on the user end to like 8 char. Is there a more secure way to go about this? The current way i handle registration on my pages is to change the iinputed data and then encrypt it in the PHP file THEN send it to mysql. Is that dangerous?
View Replies !
Setting Password Fails
The reported problem when attempting to set up a root password is; C:mysqlin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' When checking this: C:mysqlin>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: C onnect failed.
View Replies !
Setting User Password
I am having a problem getting mysql to recognize my user password. Currently I am doing everything on 'localhost' [CASE] My root password works; I have access and can create databases as root. I used MySql Administrator to create a user 'bill' and gave that user a password (billpw) different from root and applied most of the global privileges including 'CREATE'. I can open mysql with root and rootpw. As well, I can open mysql with user 'bill' and rootpw but NOT with billpw. [bill@CASE ~]$ mysql -u bill -p Enter password: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) Even when I open Mysql with bill rootpw, I get the following: mysql> CREATE DATABASE menagerie; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie' I can CREATE the DATABASE as root. I have read Section 5.7, “The MySQL Access Privilege System” and nothing seems to apply -- but that could just be newbie ignorance. Do I have some Linux permission problem related to MySql or have I done something wrong when creating my user ? How can I check for the error?
View Replies !
Setting Password Problem
i've created my database and now i want to access it through php so im using:mysql_connect('localhost:3306', "username", "password") or die(mysql_error()); but i haven't yet set a password and don't know how to, so when i run the file it comes up with the error mysql_connect() [function.mysql-connect]: Access denied for user.Is this because i need to set a password and username,if so then how? or is it maybe another different problem?
View Replies !
Setting Up The MySQL Password
I can't seem to see the page whan I am trying to set up the 'Setting Up the MySQL Password'. I know this is right at the start but all I get when I type in the Web browser http://127.0.0.1/myadmin is the sourcecode and not the actual log in page... I know it's something silly I have done or not done (I have installed the Apache / MySQL / PHP stuff over and over again, but it still does the same thing to me. The Apache services is running fine. The WinMySQLadmin is on green so I know that's fine. I think it's maybe an explorer thing? but I can't seem to get it.
View Replies !
Setting Up Password Fails
Having a problem setting up a password for MySQL The reported problem when attempting to set up a root password is; C:mysqlin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' When checking this: C:mysqlin>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: C onnect failed
View Replies !
Setting Root Password
I am using MySQL 4.1 on Win XP.I forgot my root password and I am trying to reset it. I am using the SQLyog GUI to manipulate my DB.I have a guest password stored in SQLyog and can access all of my databases.But I can't use SQLyog to change the password b/c it uses the new password alogorithm which is hashed to 32 characters opposed to 16 in the old alogorithm.I was wondering a way to reset my root password. I only have minimal privileges on this account such as SELECT. Just in case anyone missed it, I can't log into my MySQL command line client since I don't know my root password.I would normally use OLD_PASSWORD('password') from there.
View Replies !
Authentication :: Setting Root Password
I am trying to set the root password, but all I get is: $ ./mysqladmin -u root password <newpassword> ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I have no problems connecting like this: ./mysql -u mysql In the latter case, I cannot do anything. For example mysql> CREATE DATABASE one; ERROR 1044 (42000): Access denied for user ''0'localhost' to database 'MoonlightDB'
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
Setting Up Root Password For Mysqldatabase
I have Fedora Core 4 installed in my pc and I need to setup mediawiki. In the process of setting up mysql database (to create root password), I did as instructed, typed - 1. mysql_install_db 2. mysqld_safe it replies - Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 060323 15:22:34 mysqld ended but when I try to type mysqlshow, it gives this error instead mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I could not setup the root password for mysql bcos of this error.
View Replies !
Setting Mysql Root Password On Mac
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:
View Replies !
Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?
View Replies !
Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure) Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation. Where is it? i know basics about getting round terminal i.e changing directories and stuff.
View Replies !
ERROR When Setting Password Via Console (MySQL V 5.1.30
I am trying to set a password via the console with the following: mysql> update user set pasword - password<'password'> where user = 'root'; and receive the error message: ERROR 1064 <42000>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where user = 'root'' at line 1
View Replies !
Strange Password Setting Behavior In Fedora Core 4 (server 4.1.11)
I have tried adding users aided by several references and this typifies the procedure: http://dev.mysql.com/doc/mysql/en/adding-users.html But, I found that after adding them, I could not use them to get into mysql. I found my way to this reference, http://dev.mysql.com/doc/mysql/en/access-denied.html and on a hunch, set the password to '', that is, no password at all and find that now I can use them to get in. What is going wrong here? Also, I am finding that I cannot get into my database from a remote host, even though I use the '%' variable or even more directly, the actual 'RemoteHost' name.
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 !
CANNOT LOGIN
The database is accessible just fine through PHP and works great. When typing "mysql" inside a putty console I get: "-bash: mysql: command not found" I used to type "mysql -u user -p -h localhost" to log in just fine. Now mysql is not found?
View Replies !
Login Box
I have a script that uses MySQL and for some reason the first time it loads per session I get the prompt box to login to MySQL? It seems to be a session based but is just weird any ideas what is causing this?
View Replies !
CLI Login
I am able to login using the following: mysql -u$user -p Enter password: ****** But when I try to login directly from the command line for this user using: mysql -u$user -p***** and I get the following: ERROR 1045: Access denied for user: '$user@localhost' (Using password: YES) I can use my root username and password from the command line and other users. What is the difference with this user?
View Replies !
Login
I'm having a problem and I guess it's something wrong with my MySql database. I have a website where users need to register in order to login. Everything was working fine, but recently my webhost had some upgrade and my folder changed from "home2" to "home", but I'm not sure that this is the problem. Now, the new accounts are not created. The register form works fine, and appearently the account is created, but if I click to My Profile the data I completed is not there. Only the password appears but it's not the password I completed in the register form, it's the password from my Database.I also uploaded the website to a different webhost, but when I try to access the homepage, it shows like I'm already logged in, although I didn't and at the profile page, again, only a password... the database password.
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 !
Login Prompt
I have a script that uses MySQL and for some reason the first time it loads per session I get the prompt box to login to MySQL? It seems to be session based but is just weird
View Replies !
Login As Root
Im using a WAMP setup of winXP pro, apache 1.3.31, mySql 4.1.21community-nt, PHP 5.1.6 and phpMyadmin 2.9.0.2 during the install of mysql i set a root password and after setup i created a new user using a 'grant all' statement in the client console. what i want to do is completely remove the root account and use the new superuser account i created. But - i cannot login with the new account; only as root with the root password Any suggestions how i can stop mySql from forcing me to use the root account.
View Replies !
Passwordless Login
I want to be able to log in to a MySQL database without a password, but using some token similar to using ssh keys for ssh logins.
View Replies !
Phpmyadmin Login
I have just installed phpmyadmin on my server however when I try to load it im getting a username and password screen. When I installed phpmyadmin or mysql I didnt add any usernames or passwords as its just a testing server hosted localy. Does anyone know why this is happening or how I can fix it?
View Replies !
Login Function
Im creating a login function for my customers and administers. But I have some problems modelling the tables. I think I wont something like this Table usergruop Usergroupid usertyp Tabel useraccount Useraccountid fk_usergroup accountname accountpassword The question is how am I suppose to do whit the fk_keys? I need to have something like fk_costumer , fk_admin , fk_reseller because I have to have some connection between usergruop/useraccount and the tables where the costumer, resellers and admin are stored.
View Replies !
Remote Login
When logging into mysql, mysql appends '@hostname' to whatever the username you provide is. Example: > mysql -h hostname -u dsb 'dsb' becomes 'dsb@hostname.com' Does anyone know how to turn that off so that the exact username specified is used.
View Replies !
Login Question
I've read around and am still have problems. I'm tring to login to my mysql database with mysql -u username -p password database < backup I need to restore my database. It asks me for a pasword and then I get a printout of help commands. I try using just mysql -u username -p password but I get errot ERROR 1044 (42000): Access denied for user ''@'localhost' to database
View Replies !
Login Problem
New error message when I try to login: MySQL Error Nr. 1130 Server side? I edited my.cnf commenting the line "bind_address=127.0.0.1" now I get this error.
View Replies !
Login To MySQL
I've got PHP and MySQL installed, tests run good. But when I want to give a command the following error is printed: Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'mayadhiisa@localhost' (Using password: YES) in D:My DocumentsMy Virtual Websmysql_send.php on line 18 Database Selected: Query: create database baandd Results Error 1044: Access denied for user: '@localhost' to database 'baandd' Whatever I do, "I got access denied for user", Where can my settings or query be wrong?
View Replies !
No Longer Login
I've been working with a mysql installation on my laptop using apache for about 2 months. All of a sudden, I an unable to login at the root level. Specifically, I get the following message: "Could not connect to the specified instance" MySQL error 2003 can't connect to MySQL server on 'localhost' [10061] When I ping the connection, the ping is successfull. I am unable to login from the mysql command line client or MySQL Administrator
View Replies !
|
TRACKER
