Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'
Mar 26, 2010
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
View 4 Replies
ADVERTISEMENT
Dec 14, 2010
I have installed mysql-server, but i have no access. I have set the password during installation process.
Used command:
mysql -u root -p
error message:
[code]....
View 8 Replies
View Related
Feb 13, 2011
for some reason root lost grant privileges and I can't get it back. The user got grant_priv = 'Y' in the usertable. I've tried to reset all the priviliges to the user by killing MySQL process and started up again without grant options with no luck. I've also tried lots of other things but can't seem to get it work. Here is what I get: Quote:
[root@xxxxxxxxx mysqldba]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.0.77 Source distribution
[Code]...
View 7 Replies
View Related
Mar 13, 2010
I am pulling my hair out once again after trying for over 15 months off and on to get a tv tuner working under linux. I have just received my new tuner card which I thought was supposed to be easy to run, a HVR-950Q, no luck yet. But first I am trying to use something called mysql (new to me), for mythtv and [I] keep getting
# mysqladmin -u root password ma
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)
View 9 Replies
View Related
Nov 6, 2009
I can log in Mysql database successfully using
Code:
mysql -u myusername -p mypassword
Now, I need to execute GRANT PRIVILEGES. But, when I try to execute
Code:
mysqladmin -u myusername password mypassword
the below error occured
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'myusername'@'localhost' (using password: NO)'
View 4 Replies
View Related
Dec 14, 2010
ubuntu terminal. I have installed mysql-server, but i have no access. I have set the password during installation process.
Used command:
mysql -u root -p
error message:
[code]....
View 3 Replies
View Related
Nov 9, 2010
I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
View 9 Replies
View Related
Mar 14, 2011
I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
View 2 Replies
View Related
Dec 7, 2010
i have tried to follow some the tutorials on google to setup mysql for remote access however, cannot seem to do it. am i missing something.
i have edited /etc/mysql/my.cnf bind-address directive to a static ip address. then, i grant user@'%' access to database and restart mysql
after doing all that, when i try to remote access mysql i get "Access denied for user"
View 1 Replies
View Related
Jan 27, 2009
I followed this tutorial for setting up my server. Whatever I type into mysql or mysqladmin all I get back is Quote:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
View 1 Replies
View Related
Feb 16, 2011
Cannot seem to use my mysql password, keep getting the error
"Access denied for user 'root'@'localhost' (using password: YES)"
So I tried checking my password using mysql -u root -p and I get the same error as above. I've tried accessing mysql with skip grant tables disabling the need for a password so I could reset my root password. After going through the necessary steps I still get the error above when typing my password in for mysql.
View 4 Replies
View Related
Jan 31, 2011
I am not sure if this is the correct forum to post this as I have usually been able to find the answers from other peoples threads.The error I receive is below.(changed "at" as can't post links)"#1045 - Access denied for user 'root' at 'localhost' (using password: NO)" Not entirely sure what has happened here. I have had this server running for a long time and today it seems to have spat it's dummy out!I have checked the config.inc.php and the controluser and controlpass are entered correctly so the error saying a password is not being usPHP Code:Thisis needed for cookie based authentication to encrypt password incookie
View 2 Replies
View Related
Apr 18, 2011
I have a new CentOS server install. I am trying to connect from a windows xp box using putty ssh. I can get as far as putting in the password for root user and then it tells me access denied.
View 2 Replies
View Related
Dec 2, 2010
I have been following this guide to install Apache, PHP & mysql - [URL]. When I get up to the step 'mysql -u root' I get given this error:
Code:
tom@tom-laptop:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
How do I overcome this?
View 2 Replies
View Related
Feb 28, 2011
I need to get an old MySQL Client(4.1)to connect to an even older MySQL Server (3.23).The goal is to do a Java/JDBC connect to the old Linux/MySQL 3.23 database, in order to update text information for a Lucene search (which will also run on linuxdev2). The problem is that I can't connect to the Linux/MySQL 3.23 server from a remote Linux/MySql 4.1 client. I can't connect from JDBC; I can't connect from "mysql":
Code:
LOCAL (intranet):
mysql -uSOMEUSER -pSOMEPASSWORD mysql => OK
REMOTE (from linuxdev2):
mysql -uSOMEUSER -pSOMEPASSWORD -hintranet mysql => FAILS:
ERROR 1045 (00000): Access denied for user: 'SOMEUSER@linuxdev2' (Using password: YES)
[code]....
View 1 Replies
View Related
Apr 13, 2011
I've tried every manual there is for creating new MySQL users ... but without success.
I keep getting
Code:
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES) even though I just created it with all privileges ... WITH a password that I DO remember .
Fortunately I still have access via the MySQL root user (so I try not to disturb that user, because I have had computers with THAT account not accessible as well - even WITH resetting the password via skip-grant-tables).
View 5 Replies
View Related
Oct 21, 2009
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
[Code]...
View 2 Replies
View Related
Nov 28, 2010
How do I set up a server to where it does not give a password prompt to access a shared folder?
View 1 Replies
View Related
Aug 1, 2010
Following guide for CentOS 5.5 i've installed mysql server on my box.Next step was setting up password for root user.As you undestood, it failed. output:
Code:
# rpm -qa | grep mysql
mysql-devel-5.0.77-4.el5_5.3
[code]....
View 1 Replies
View Related
May 6, 2011
Error: Cannot connect to the database because: INSERT command denied to user 'webuser'@'localhost' for table 'visitor'
[Code]...
View 3 Replies
View Related
Jan 13, 2010
I am up and running. Symptom: webapp/servlet deployed to Tomcat, utilizes JDBC driver for MySQL connectivity. Upon launching application in browser and performing action requiring database interaction, exception thrown, server log:
[Code]...
View 1 Replies
View Related
Jul 3, 2011
i setup a localhost in my system. but am not getting access to the phpmyadmin by entering the user name and password i entered at the time of set up. the /etc/phpmyadmin/config-db.php file is shown below.
<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
[code]....
when i access http://localhost/phpmyadmin/ , the login screen appears but entering the username and password as in the file gives the error #1405 cannot log into mysql server.
View 3 Replies
View Related
Sep 7, 2010
I have forgotten my root password for MySQL, what can I do to recover it, I've found a few guides but they don't work on the newer versions of Ubuntu.I am running on Ubuntu 10.04 server so MySQL is an upstart job so the methods I've seen with launching it without the access checks haven't worked for me
View 4 Replies
View Related
Oct 14, 2010
I have forgotton my root password for mysql. I followed some instructions on a website and now I am not sure what i have done?Basically, when I now try and start mysql I get a notification that i have converted the init script to an upstart. I dont know what this means.
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the start( utility, e.g. start mysql mysql start/running, process 20301.
View 1 Replies
View Related
Aug 19, 2011
Using 11.04, and just installed mysql 5.1.54 using synaptic
I was following the instructions here and the installation when fine,
except that I never got a screen to set the root password.
When I try to set the password using these instructions, following either
"If you have never set a root password for MySQL" $ mysqladmin -u root password NEWPASSWORD
OR, since the first method failed me, then: "However, if you want to change (or update) a root password, then you need to use following command" $ mysqladmin -u root -p'oldpassword' password newpass
Either way, it fails. Question:
1) why am I not being prompted to set a root password during installation?
2) what can I do now to fix this??
I am trying to learn Mysql, so don't presume I know anything about command syntax (cookbook instructions) For example, the first command above,I tried with with NEWPASSWORD in quotes, and then without. Likewise for the second command.
View 9 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jul 16, 2011
I forgot my root password for mysql, and after some searching I found several solutions to fix it. But none of them seem to work.I tried this article http://ubuntu.flowconsult.at/en/mysq...root-password/ with starting mysql with the --skip-grant-tables option. The problem is that nothing happens, it just hangs.Also tried the the --init-file option, that one runs fine, at least it returned to the command line. But the sql query in the file to which it point doesnt seem to do anything. The password wasn't changed to the one I specified in the sql file.Any idea what could be going on here, and how I could fix it?
View 3 Replies
View Related
Feb 20, 2011
I'm having a hard time to access MySQL from the local or remote shell.
If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...
MySQL is running and I can access it, using phpmyadmin.
There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access?
I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information.
I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.
View 1 Replies
View Related
Dec 11, 2010
I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
View 4 Replies
View Related
May 8, 2010
I wanted to setup a local Apache2 server for some programming and testing. I installed and got Apache2 working with PHP, MySQL and all works fine. Now I wanted to add an additional directory to somewhere in my /home. And that's where things went wrong. I went to edit /etc/apache2/sites-available/default. This is it:
Code:
<VirtualHost *:80>
ServerAdmin webmaster@localhost
DocumentRoot /var/www
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory /var/www/>
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
Code:
You don't have permission to access /po/ on this server.
So I go to the logfile; which says this:
Code:
[Sat May 08 16:43:51 2010] [error] [client 127.0.0.1] (13)Permission denied: access to /po/ denied
I tried a lot of stuff using chmod and chown, but all to no avail. I tried to change the ownership of the /home/name/web to root, and to www-data, I changed file permissions to allow executing the files.
View 6 Replies
View Related
