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 Complete Forum Thread with Replies
Related Forum Messages:
Adding Mysql User - Only Root Is Able To Login From A Remote Client.
hey all. need some quick help with user admin in mysql. so currently, I have a linux box with port 3306 open or mysql administration using navicat. I'm able to connect to the mysql server through navicat if I'm using the "root" username. For some reason, whenever I atmysqlt to add a new user to mysql, i'm not able to connect to mysql through navicat or the mysql prompt. First, trying to add user for localhost: INSERT INTO user (Host,User,Password) VALUES('localhost','aaron',PASSWORD('abc123$')); Then grant privileges: GRANT ALL ON *.* TO aaron@localhost; Now when I try: $mysql -u aaron -p I enter in the password (abc123$) and it tells me access denied.. What am I missing?
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 !
MySQL Root Password
I am having some trouble setting up the mySQL root password. It's probably right under my nose, but I can't seem to find where to edit it.
View Replies !
Mysql Service And Root Password (-w W)
I have a few qeustions for some linux/mysql pros in here. Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql: alias=/usr/local/mysql/bin/mysql but it won't span sessions, I think I need to export it, but I'm not sure how to. Also, via mysqladmin I set the root password to "password" which I don't want to keep :) how do I got about changeing it now? I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.
View Replies !
Change MySQL Root Password
My current user/pswd for my localhost is root/"" (no password). I'm following the directions in the mysql command line window (im on windows and installed mysql via wamp) and can't get to change the darn thing.
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 !
Mysql Root Password Problem
i m new to learning mysql and php.i m following Kevin yank's build your database driven website and i am following well but i m stuck on one problem that is when i star mysql or connect it and give him my login and password of root.it give me error which says 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 !
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 !
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 !
Root Login Only
I have tried to create additional users with GRANT and INSERT INTO (FLUSH PRIVILEGES) but every time I start the mysql client only with the root password can I successfully login. How do I get it so I have to enter a specific user name then be prompted for password?
View Replies !
Fail To Change Mysql Root Password
I followed; http://www.cyberciti.biz/faq/mysql-change-root-password/ to change MySQL password. $ mysqladmin -u root -p oldpassword newpassword Enter password: (enter Mysqladmin Password here) mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' As root # mysqladmin -u root -p oldpassword newpassword Enter password: mysqladmin: Unknown command: 'MysqladminPassword' I succeeded changing MySQL root password with following steps; $ mysql -u root -p Enter password: oldpassword mysql> set password = password("newpassword"); Query OK, 0 rows affected (0.32 sec) mysql> quit Then I can login MySQL with newpassword. I don't know why; $ mysqladmin -u root -p oldpassword newpassword did not work?
View Replies !
Unable To Set Root Password On New Mysql Install
I've freshly installed CentOS v 5.2. I've freshly installed MySQL: yum install mysql mysql-devel mysql-server php-mysql All seems to have gone well, I see no error messages. I then did this to make sure MySQL starts when the server powers up (and started mysql): chkconfig --levels 235 mysqld on /etc/init.d/mysqld start Now, I do this to see if networking is enabled: netstat -tap | grep mysql It tells me this: ....
View Replies !
Changing Forgotten MySQL Root Password
I get an error like this when trying to fix the password with safe mode and mysqladmin: ERROR 1044: Access denied for user: '@localhost' to database 'mysql' Here is what I have done so far: Command: mysqladmin -u root -p <oldpw> password <newpw> Outcome: mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' I have performed everything in the MySQL Manual section A.4.1 How to Reset the Root Password. Same outcome same error. I dont get it. What is going on. I have researched this for about 6 hours now with no luck. Finally going to see what the "experts" have to say.
View Replies !
Forgotten Root Login.
I need help resetting my root login. I've lost my password. I've uninstalled MySQL and reinstalled it hoping that it would work and no luck. How do I go about doing this? I'm operating on OSX.
View Replies !
Root Login Can't See All Databases
When I login as -u root, only test database can be seen, not others which were seen the last time I logged in as root. All databases are there in the data folder and no passwords were changed; what could be causing this?
View Replies !
Root Login Problems
I'm not able to login to mysql via root... strange things are happening. I type in mysql -u root and I get ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) So, follownig the tutorials on the mySQL website, I kill the process with kill `cat /var/lib/mysql/linux.pid` which stops the process just fine. Then I start it back up like so: mysqld_safe --skip-grant-tables & And it starts up okay, the pid appears again in the subdir. Then I can log in okay via mysql -u root However, then I try to reset the password via: UPDATE mysql.user SET Password=PASSWORD('pwordhere') WHERE User = 'root'; okay fine that takes okay. I do a query with select, seems fine, do an exit to get back to my prompt. type in mysql -u root... and viola, same error appears, ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
View Replies !
Restart MySQL Service After Root Password Change
I installed mySQL on a Win2k machine and tried to change the root password, which didn't seem to work. I changed it this way: c:>mysql mysql> use mysql mysql> update user set password=PASSWORD('test') where user='root'; mysql> exit and then tried to login this way: c:>mysql -u root -p password: test which didn't work. Then, after many unsuccessful attempts, I restarted the service and suddenly the password I had set worked. Then I realized that (at least for the root password) I needed to restart the mySQL service everytime I changed the root password, otherwise it would not become effective. Is this by design??? Am I doing something wrong?
View Replies !
Having Root Login Problem With Sql5.0
I just install the FC6 on my machine and also install httpd ,php,mysql5.0.27,proftpd.now with mysql im trying to setting up the pass and user for my mysqladmin -u root password "new-password" im getting this error message /* ysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' infact i just try to login using mysql for resetting my password for update mysql.user set password=password("NEW-PASSWORD") where user="root"; flush privileges; quit root but getting this anoying error update mysql.user set password=password("*******") where user="root";ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user' Code:
View Replies !
Disable Remote Root Login
I would like to keep root non password protected locally. And disable root login via phpmyadmin and other remote mamagement tools. For remote login I would have seperate users set up.
View Replies !
5.1 Login To Root On Windows XP Professional
I installed MySQL 5.1 as a service on XP Prof SP3 and it is running. I got up the black DOS window and tried to login as root Under Fedora 9 I had no problem. I am administrator on XP Prof SP3 I tried : C:Program FilesMySQLMySQL Server 5.1in>mysql ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) C:Program FilesMySQLMySQL Server 5.1in>mysql --user=root --password='xxxxxxx' ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ....
View Replies !
Installation :: With Apache, Unable To Login As Root
I have just started working with Apache, PHP, and MySQL. I had installed MySQL and was working with with marginal success. I tried installing Apache today and everything went crazy. I am running the Apache in a localhost configuration and MySQL as well. After the installation, I could not log into MySql root. I began to think I had forgotten my password so I attempted to reinstall MySQL. I uninstalled it and rebooted my computer but evertime I attempt to install it stops on the step before setting the security, I think it is when MySql is configuring the host. I do not have Apache running as a service. So with Apache running or not, the MYSql install fails.
View Replies !
Direct Link To Login As Root On Windows
Anyone know a direct link to loging in as root on mysql on Windows 2000, and creating and seting up user permissions for new accounts? :- i try to look at the windows specific info in the manual.html but it freezes up my IE .
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 !
Login As Root User, And Grant Create Database Privileges
I am new, and I have been trying to find info on this unsuccessfully. Ok, so I am using Unix Terminal from my Mac. From the command prompt, I use Shell>/usr/local/mysql/bin/mysql to log in to the localhost user. Now, from the command prompt, i have tried using ,mysql -u root, and it says command not found!
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 !
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 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 !
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 !
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 !
Can't Set Root Password
Not only is this my first atmysqlt at installing MySQL, I am also a Linux newbie which compounds my problem. Please be kind. When the issue cropped up in a fresh install of openSuSE, I tried it on CentOS and the same thing happened. When I issue the following, as Linux root: mysqladmin -u root password <new-root-password> I get the following: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Something is not allowing a connection to the server. I have made sure the entiries in /etc/hosts are correct. I even added a search line in /etc/resolv.conf thinking some persnickitiness with the hostname might be the cause. It appears I was wrong on both accounts. Then is suspected permissions as the devil. Wrong again. I went so far as to chmod 777 every file associated with mysql to no avail. The line "(using password: NO)" in the error message also has me scratching my head. I am pretty sure it is something very simple that I am overlooking. Or, at least, I hope so. Anyone have any ideas that will maybe get this newbie's jitney back on the highway?
View Replies !
Don't Know My Root Password
I had just installed MySQL 5.1 on my system and was in the middle of configuring it when my system had just randomly crashed. Now I wasn't able to set a root password and when I try to configure it now, it says there is a password but I don't know what it is. Is there a way to completely uninstall MySQL from my system so that it no longer has a password or anything without completely reformatting my computer? I've tried the method to resetting the password here.. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
View Replies !
Password Except Root
I know that there is default user and password in MySql as root and admin, but i want to create my own user and password like xxxx as a user name and yyy as a password so please tell me the procedure to create the user.
View Replies !
Root Password / Startup
I'm using mysql-server-3.23.58-4 on a Linux (Fedora 1) machine, and I'm new to databases/MySQL. After reading the security section of the manual from http://dev.mysql.com, I added passwords for the 'root' accounts. However, now the startup script (/etc/rc.d/init.d/mysqld) fails. I tried adding: [mysql.server] password=xxx into /etc/my.cnf How do I set the password for the startup script ?
View Replies !
Forget Root Password
i've installed OCS Inventory NG for inventory and it has installed Mysql ver: mysql Ver 14.12 Distrib 5.0.18, for Win32 now i have to make a dump for save database but don't forget the root password.
View Replies !
Resetting The Root Password
Having a browse through Paul Dubois's book, MySQL (ISBN 0-7357-1212-3), I came across a section in which he describes how to reset the root password: 1. Shutdown the server by issuing a KILL under Unix or stopping the system service under Windows. 2. Restart the server with the --skip-grant-tables option which allows you to connect with no password and all privileges. 3. Reset the root password. Given that the person first has to have operating system root or administrator access to shutdown the server, wouldn't this qualify as a security hole in cases where the OS root doesn't own the database, for example, on shared machines.
View Replies !
Cannot Connect With Root Password
I've set my root password (or at least I think I did!), but am unable to connect to localhost with it. Now when I try to connect using root and that password - i receive a 'command not found' error.I'm totally perplexed. This is a new installation and I 'thought' I followed the instructions - but apparently not. Can I remove this installation (and how would I do that?) and try to install again?
View Replies !
Reset Root Password
I have searched on several forums on how to reset the root password for MySQL. Keep in mind, I am NOT a SQL programmer at all. I have been taking a stab at getting a phpbb up and running. I did all of this on a desktop machine running apache, php, phpbb, & mysql. Now that the site is up and running, I want to move my database over to my server using phpadmin, but it requires that I know the root password. I typically use 2 different passwords, both of which I tried and can't get root access. I don't understand what happened. Can someone let me know what the exact commands are to reset the password? Yes I am a dummy when it comes to this
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 !
Retrieve Root Password
I have a dedicated server with 1&1 (really bad tech support) and they don't seem to want to give me the root user password. The server is running Fedora Core 2 - is there anyway I can retrieve the root password? I want to be able to set CRON jobs to do MySQL dumps for backups every now and then.
View Replies !
|
TRACKER
