Software :: Cannot Access MySQL Server Other Than User=root?
Apr 13, 2011
I've tried every manual there is for creating new MySQL users ... but without success.
I keep getting
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).
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?
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 :-
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)'
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 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
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
I'm using an older redhat system (2.6.9-22.ELsmp) here which is running an older mysql (server version: 4.1.12). I don't think that's the source of the problems. I believe that have understood things rightly when I say that the mysql root user is unrelated to the linux root user ... in my case I believe the root user to be the unix user mysql. So when I connect to the server (local host from a local terminal) I use: Code: -bash-3.00$ mysql -u mysql -p and enter a blank password
This gets me on, however I seem unable to do anything like create database or alter privilege. I wonder if its related to my finding no database called mysql? -bash-3.00$ mysql -u mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 11 to server version: 4.1.12
Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | test | +----------+ 1 row in set (0.00 sec) Although I understand that show databases will not show things I have no priv to see. Does this mean my settings for the users are all screwed? How do I rectify this situation? Some other (perhaps) useful information.
Code: [root ~]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
So my BASEDIR seems to be nothing like is suggested in the documentation at [URL].
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code: GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password"; I get the output:
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 cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:
I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.
I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.
I Installed the maintained package, Day one everything worked fine, I set a dummy database and work on it from VM windows. Day two weird errors, I searched around couldn't find the problem, the error was related to The root user losing privileges. I don't remember the exact error. So I decided to Completely remove the DB with apt-get remove mysql-Server-5.1. It gets stuck during the uninstall, I left the machine for a day and a half to uninstall mysql. I realized it was no use, I tried to Restart and try again, but I am getting the same thing.
Code: finito@finito-desktop:~$ sudo apt-get remove mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state information... Done
The following packages will be removed: mysql-server-5.1 0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded. 1 not fully installed or removed. After this operation, 15.7MB disk space will be freed. Do you want to continue [Y/n]? y (Reading database ... 231901 files and directories currently installed.) Removing mysql-server-5.1 ... it stays stuck at Removing mysql-server-5.1 ...
I can't progress I am at the brink now, my only option right now is format, but I don't wanna do that. This setup is almost 5 years old and I have gone with many ups and downs with it. From Windows to 8.04 to 8.10 to 9.04 to 9.10 to now 10.04 each year loving the resilience of Ubuntu and the Linux architecture. I don't want to believe that this has killed my spree.
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.
i want to install a software in my linux machine staying in another user that i have created .It is asking for root access for some command to be execute during installation process.when I am trying to execute "sudo -s" its showing " is not in the sudoers file. This incident will be reported.".what next will i do.I am in my ubuntu machine.
It's been a few years since I last installed Ubuntu. I searched the forums and can't seem to find the answer. I want to be able to do a "su root" and have root access. I know Ubuntu wants you to do the sudo command, and I know you can really mess things up being root. I know I got this to work before. What do I need to do?
I have a system running with few users and servers (apache/mysql/postfix). After extracting one tar archive in '/home' none of my users are being able to access their home directory. Even other system users (like www-data/mysql) are also not being able to access any directory. Only root can access the system. I have checked file permissions, many files/directories are set to 777 rest are 755.
I have a LAMP server running. Currently there are not vhosts, just the basic single site apache2 running a web app. I want to set up ftp access to the www root, but my attempts have failed. When I try to ftp using the user I created, I get dumped in the users home directory. I can also browse the entire file system. What I can't do is upload content to the www root. I get permission errors. How can I set ftp up to allow a user to access the www root only?
So I'm attempting to get my system to not require the root password while still requiring some form of authentication. My current issue is getting yast2 and its components to ask for the user's password and not the root's.
Is there a way to have these tools ask for user's password instead of root's?
After a week of working with Debian, I decided to install the KDE3 version straight from an NetInstall CD. This fixed some issues for me as well as made networking and folder sharring a snap! But now its time to add all the extra packages I need.
Here's the problem: Using any kind of Package Manager yields the same results: E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable) E: Unable to lock the administration directory (var/lib/dpkg/), in another process using it? RESULT=100
I've tried apt-get from root command line and the KPackage Manager that comes with KDE3 with same results. I have only one user that was created during Debian install. I'm having some other problems, from what I've seen on the net, they all seem to point to not having proper Super User access (I'm guessing here). What could cause this error? AND/OR How do I make sure I have top level access to the configure the system? (I tried logging in as "root", but the login errored out saying that this was not allowed).
How to allow access to some commands having root privleges to be run by non root user. I am new to unix/linux and I have a major assignment. I have to find ways to run particular commands which can be run only by root from a non root user. I know sudo is one of the way but i need some different approach.
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?