OpenSUSE :: Cannot Login To Mysql As User Other Than Root?
Feb 8, 2010
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:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
View 6 Replies
ADVERTISEMENT
Feb 5, 2011
i am having problems with privileges i have created a new user with my name, but i cant get root privileges on it. i need the same privileges as the root profile.
View 9 Replies
View Related
Apr 14, 2011
I have two uesers on the syste - me (Adam) and the root. when I log in as root where is the admin user contents? in windows its under users. in suse it should be under users. but where?
View 2 Replies
View Related
May 10, 2010
I have installed OpenSUSE a few months ago and worked fine. But from yesterday i can't login with root user. I received the message:
Login: root
Invalid user name
I have no question for password neither.
View 9 Replies
View Related
Aug 13, 2009
How can I enable "Auto Login" for root user?In " Yast --> Security And Users --> User And Group Management --> Expert options --> Login Settings " is just my own user and there's no root user to choose.
View 9 Replies
View Related
Feb 19, 2010
I need to run a script (which requires root privileges) on login per-user only. I want this to runtomatically so I'll add an appropriate line to .profile.A couple of questions:1 The easiest way I can think of to run the script as root is to setuid, but I know there are security concerns. Is there a better way
View 6 Replies
View Related
Dec 2, 2010
i just installed linux mandriva 2009. i set password for root and created a user account. when i try to login as root, after logging out as user, it does not allow me and gives the error "root logins are not allowed". even it does not show the root account. if i try to go to root from konsole terminal using su root, it allows to enter as a root but when i try to start the GUI with startx it gives error.not sure what to do and why i can't see my account in GUI mode
View 5 Replies
View Related
Jan 4, 2011
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.
View 5 Replies
View Related
Jun 22, 2010
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].
View 2 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
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
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
Jul 21, 2011
Since I have never had the need to create one, the first time I encounterd it I asked myself: what is it?I was looking for MySql installation guidelines on mysql.com, when, reading them, I found this command:shell> useradd -r -g mysql mysql.Now, I read the man page of useradd looking for explanation about -r option, but I didn't found it useful.It just says that -r options creates a System account, but it doesn't say anything else.So my question is: what is a system account? Few lines under the command it says:"Because the user is required only for ownership purposes, not login purposes, the useradd command uses the -r option to create a user that does not have login permissions to your server host."What would be the benefits if mysql user has not login permission?
View 6 Replies
View Related
Jul 20, 2010
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 were automatically installed and are no longer required:
dbconfig-common libhtml-template-perl mysql-server-core-5.1 libaprutil1-ldap
apache2-mpm-prefork apache2-utils libmcrypt4 apache2.2-common libt1-5
libaprutil1-dbd-sqlite3 apache2.2-bin wwwconfig-common php5-common
javascript-common libjs-mootools
Use 'apt-get autoremove' to remove them.
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.
View 9 Replies
View Related
Jun 17, 2011
Well I did something pretty stupid and now I can't log in with my user other than the root user. Basically, I wanted to change my username and so I when to the admin > user & accounts - and selected the account I wanted to change. Anyway I did that and then logged out. Since then all I get when I reseted is a spinning mouse ball and a black screen. I can get into the shell prompt - but I'm not sure how I'd go about fixing this issue I created. At the moment I'm logged in the shell with root, and if I type 'id' I can see my old username, but I think the links behind it are broken.
View 5 Replies
View Related
May 26, 2010
how i know am in root user or another user? how to login as root user? sudo passwd root when i typed in termninal am getting this error pa1 is not in the sudoers file.
View 2 Replies
View Related
May 21, 2009
I created a new user lets call it X. I disallowed the root login from SSH, so I login with X and after I call "#su root" command. But when I login that way, I can't use some commands like "service". I can access all the files, I can even change the sshd_config file but some commands say "not found". Do I need to get X to a group? Or make it some priveledges etc? What should I have to do to run this free of problems?
View 4 Replies
View Related
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
View Related
Sep 24, 2015
Since upgrading my Debian/unstable amd64 installation a few days back I can no longer log in as either root or user, whether to SDDM, via the console, or via ssh. When trying with the console, I can see the login message flash briefly on the screen, before the console resets itself.
I can boot into recovery mode, and examine log files. I enabled systemd debug logging and, amid reams of messages, these seem the most pertinent:
Sep 25 02:24:43 cooler systemd[1]: Received SIGCHLD from PID 937 (login).
Sep 25 02:24:43 cooler systemd[1]: Child 937 (login) died (code=killed, status=6/ABRT)
View 7 Replies
View Related
Sep 8, 2009
I have a problem, I have installed Fedora 11. And i need to login as root user.
How to do so?
View 14 Replies
View Related
Dec 18, 2009
I've recently upgraded my hardware. Now, the system boots perfectly fine, but I can't login to the tty as root or any other user. Infact yes, I can login, but as soon as it shows Last Login, it exits and then I'm back to a login prompt. I've successfully booted into single user mode, and changed all the passwords, but still it fails. X doesn't start, although I think it's due to the old xorg.conf having the wrong driver.
View 9 Replies
View Related
Jul 6, 2010
After upgrading FEdora 13, user ravi was added. Then after few days neel was added. Both of the users were already existing. So when attempting login to neel, we found that every file is owned by ravi. So we did$chown -R neel:neel But after that problem started and when we rebooted the machin, there were no list of users on login screen. (then I connected to that comp remotely, it worked, but somehow I was not able to switch to root) It says incorrect password (though I new it very well). So I went to maintenance mode and changed the root password, and rebooted. Still problem persists.Now I am not able to login as root (from anywhere, login screen , terminal, remote)No list of usernames on login screen ( but i can choose, other and type login-password)
View 5 Replies
View Related
Nov 2, 2010
I hate my touchpad when my mouse is plugged in, and because of a bug in the alps touchpad that the system does not shut off the touchpad when I am typing. and syndaemon does not work either. So I found this script that I modified and it works like a champ when run as sudo from a command line, but I can not get it work from root crontab with the "@reboot" and it does not work with
Code:
sudo update-rc.d killtouchpad start 30 2 3 4 5 . stop 70 0 1 6 .
here is the script.
Code:
#!/bin/bash
#
# Toggle touchpad on and off
[Code]....
View 3 Replies
View Related
Jan 14, 2010
I have just upgraded my laptop from F8 to F10, and I am unable to login to the system as root user.At login, it provides 2 options, one is the user I created and another called 'other'.On selecting 'other' and providing uid/passwd as 'root/<rootpassword>, it says "Unable to Authenticate User"!!However, when I tried to access my windows partition, it happily accepted the root password
View 4 Replies
View Related
Oct 12, 2009
I want to disallow root login on my RHEL Machine?
View 14 Replies
View Related
Feb 12, 2010
I have been trying to establish a connection between two pcs via the ssh channel. I successfully made the connection as a root user, but when i tried as a non root user i had to type in the password the make contact with the other pc. how exactly does this passwordless login actually work?
View 3 Replies
View Related
Jan 29, 2011
I am trying to someone get to their records on a CentOS 5 box and the username/passwords they have given me are not being recognized.
View 11 Replies
View Related
Aug 4, 2010
When I try to login root from my normal user, I can see this:
Code:
Cannot exec /usr/libexec/openssh/sftp-server: File or directory doesn't exist
(Translateted from my nativ language)
I think that is my bad shell configuration so I check file /etc/ssh/sshd_config and see in the end (this lines couse this bug):
Code:
Match User root
ChrootDirectory /home
AllowTCPForwarding no
X11Forwarding no
[Code].....
View 2 Replies
View Related
May 26, 2015
Debian 8/Cinnamon fresh install. /home is being shared with two other OS's, Mint and openSUSE. At the login screen I enter my user name and password and the screen blacks for 1-2 seconds and comes back asking for user name and password. I can login as root. As root I can launch the Group & Users GUI and attempt to set the user's password, and pressing the 'change' button does nothing obvious.
I can set the user's password in a terminal, which reports success. I tried to switch users and login with the changed password and I get the same failure. If I try to login with the original password I get an incorrect password error, suggesting that the password is being processed properly and the problem is elsewhere.
On previous installs with Mate and the default desktop (Gnome) I didn't have this problem. So, the questions are: Is it Cinnamon? Is it an unlucky chance bad install? Config files are typically in /home, which is being shared with Mate and KDE, is this the problem?
View 3 Replies
View Related
Apr 7, 2010
I have fedora 12 installed in my system.But i cant login into it as root user even using 'sudo su'what to do?Each time i am having the following problem
[sujal@hclhome ~]$ sudo su
[sudo] password for sujal:
sujal is not in the sudoers file. This incident will be reported.
View 5 Replies
View Related