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
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]....
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)
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]....
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]...
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)
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 RelatedI 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)'
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)
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 RelatedI 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 RelatedI 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?
Hey I have made a user so that he is able to access my ftp files though filezilla.
However he does not have access to the root folder. How can I edit this?
I've just upgraded my laptop to Fedora 14 and installed LAMP on it for a test environment. I've followed the official instructions to install but seem to have a problem that I didn't have on F13 or Opensuse. Each time I try to access index.php on localhost I get a permission denied message and an SElinux alert. I have tried 7 different solutions on various forums and just can't view anything in a browser.
/var/www/html has been set to chmod 777
/var/www/html/index.php has also been set to chmod 777
A standard user can definitely read and write to the above files/folder. Until I commented it out the Welcome/Test page was working perfectly.
I am going to remove root access via SSH which seems fine but I don't know how to add a new user, do I have to create a group first or are there existing groups I can add a user to, and does it matter which group I add a user to if I want this user to have root access with sudo?
View 11 Replies View RelatedError: Cannot connect to the database because: INSERT command denied to user 'webuser'@'localhost' for table 'visitor'
[Code]...
I configure named and stumble upon the following problem: named is serious about user rights, every config file named uses should be named:named. I set rights to named:named as follows, but they get changed to root:named when I restart named as root. The same thing happens with SELinux context. This results in access denied type errors.
View 1 Replies View RelatedI have been trying to run the following commands several times in the last coupl weeks, to no avail."su" to get to root...then while root "apt-get update" for updatesalso"sudo apt-get update"BOTH areenied even with root or user-admin pwd.States that either permission is denied and/or frequently states that the command "apt-get" does not exist
View 4 Replies View RelatedCannot 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.
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]...
Prelude: OpenSUSE 11.2 (2.6.31.8-0.1-desktop), installed Novell client 2.0 SP2 (novell-client-2.0-sp2-sle11-i586.iso).
I found that if any usual user is logged into a NDS-tree, then _local_ root has full access to user's network shares, including the user's home directory located on remote Netware-server. Is it by design or
have I missed something? Nevertheless in windows local admin has no access to network resources mounted of any other user. If you runas shell (as admin) then admin in principle can't "see" network shares which were mounted (connected) by other users - they are accessible ("visible") per session.
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"
I keep receiving the error message in the title above whenry to enterebmin.abc.com/webmin. I'm on Ubuntu 9.10. Other errors I'll receive are "You do not have access to any Webmin modules". Wondering if anyone knew what settings our permissions on files I could change to avoid these error
View 1 Replies View RelatedI 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]....
Whenever i try to create a account either then the root and login as it i get a error Access is Denied if though the password is correct.
View 3 Replies View RelatedI've only recently encountered this problem with vsftpd when I was creating new ftp accounts. I keep on getting:
550 Access Denied.
on every action I try to do on ftp, no matter what. I've been trying to solve this myself however my attempts have been futile.
The permissions, and ownership have been checked and rechecked tens of times now, so thats not the issue. I've reinstalled the OS of my server twice now, and the problem is still persisting. Heres my config file, this isnt for anon by the way.
Code:
# Example config file /etc/vsftpd/vsftpd.conf
#
# The default compiled in settings are fairly paranoid. This sample file
# loosens things up a bit, to make the ftp daemon more usable.
# Please see vsftpd.conf.5 for all compiled in defaults.
#
[Code].....
Has anyone seen this? I have attached a screenshot of it to this post.
When I log in using PUTTY, as soon as I enter my username and hit enter I get Access denied, then a prompt for a password and all works well, it just tells me access denied even though it didnt deny me. its weird.
I am getting an access denied when trying to log in via SSH to my home server with putty(windows) over the internet. I can use any user including root and get the same result. If I use my Android phone with the ssh terminal command I am able to successfully log in and use the server.
View 1 Replies View RelatedI recently installed CentOS 5 as my server. I have samba running 100%, today i was working on NFS i had it semi working at one point where i could mount to the shared folder but i could not see any of the files in it, now when ever i try to access it i get, mount.nfs: access denied by server while mounting 192.168.1.100:/Server
View 11 Replies View Relatedwhen client goes to bind to NFS share on remote server - they are getting access denied when using the mount command; [SERVER] - CentOS 5.3 /etc/exports /mnt/data 192.168.5.199(rw) - implying the client I want to have access
[Code]...
