I'm running Suse 11.1. MySQL is installed. I downloaded and installed the software for MySQLAdmin and MySQLBrowser, this was one software package so both got installed at the same time. My question is this; When I log into MySQL to use the Admin Tools it doesn't like my root password. So I log in as 'localhost' with the id of 'root' and no password and I get right into the main Admin menu. Why doesn't it accept the root password and how can I change the root login to need to have a password. Will just changing the password in MySQL Admin do the trick?
I keep having issues at the main password screen. The computer starts, I click my login name, type password, start to hear the music, screen distorted, then reboot. Sometimes I have to do this up to 20 times before it finally logs in.
I am running a Biostar U8668-D Motherboard with 1gb ram. Video is onboard. I am not sure what type. I think it may be S3 Pro Savage.
I went away this weekend and everything with my mysql server was working great. I got home on sunday, and I found that my web pages couldn't be displayed because they were unable to gain access to the mysql database.
I am now not able to log into mysql using root or debian-sys-maint. I get error messages.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I have tried loading mysql in safe mode, and changing the passwords, but this does little to help me.
I am unable to retart my services without them failing, so after making the changes i have to manually kill the processes for mysql to get it to stop. After doing that i try to start mysql up, and it gives me a .sock error. I will post some of the errors in my next post, but if anyone has a general idea what i can try to manually override the passwords or reset them. I did read that i can reset the debian-sys-maint password using the msql/rm.conf , but i am unable to log on as root to change the password
I accidentally promoted my initial account to admin and now I want to revert it but I don't remember the specific initial user privileges.So there are 2 questions:
1) First, is it safe to "downgrade" the account, logging in with another one? In general what's the best way to do it?
2) Could someone enter Administration->Users and Groups->[select initial account]-> Advanced Settings->User Privileges and list the privileges that are on by default?
I repeat I want the privileges of the initial account, which I suspect are above those of basic users (that are added later) and below admin...
Is there anyway to prevent a user from being able to logon at a machine (Terminal and XWindows) but allow that user to logon remotely using SSH? This user is for remote capture of logs only - on a private network (no internet access).
In fedora 14, the user order on GNOME login screen is completely different from that in fedora 13. Is there any way to order the users by date of creation ASC, not by name ASC?
Also, it is completely random. This time when I started my computer, my account was listed first. When I started this thread, it was listed last. What's happening?
Does anyone know how to install the Default KDE Desktop settings in an existing user? I copied a user's home directory from another Linux and when I added the user using adduser on the new intallation, it did not copy any of the Desktop or other .rc/.profile settings.
Is there a script that is run by adduser, or a list somewhere of the files that are needed for KDE Desktop to work correctly? Or, do I delete or rename certain files and then, what executable do I run to get the Desktop?
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:
If you need to to exclude one or mode user from your gdm login window you must edit "/etc/gdm/gdm.schemas" and add the user you want exclude from the <key> "greeter/Exclude" (near the other user in <default></default>)
Sometimes my user list is empty on start-up. When it happens the buttons beneath the empty list (shutdown, suspend and restart), are not responding. As a work-around I login to the first terminal as root to restart the machine and usually my normal user account appears back on the list. This morning the reboot work-around didn't work any more..
having a hard time mapping a drive from a windows xp PC to a Linux Share. I have edited the SMB.conf file to include the share I want to connect to. when I try try map a drive to the Linux share using NET USE M: \192.168.15.5pairing I get the following error:"system error 1326 has occurred.Logon filaure: unknown user name or bad password."I use a username and password that is valid on the Linux server and has access to the Share.
Our system is based on RH4 and is using pam_tally and faillog to record failed attempts and to lock users out after 5 attempts. We have a requirement to provide a normal (non-root) user logging onto our system, with information regarding the number of failed logon attempts made on their account before the current successful logon (similar to the functionality provided by HP Protect Tools on Windows). My first idea was to add 'faillog -u $USER' to the bashrc, however by the time the bashrc is run - the user has been successfully authenticated and the faillog has been reset back to zero.
I have got a RHEL 5.6 server configured to authenticate via a Windows 2008 domain controller via LDAPS.Everything is working fine, except from the following: When I create a new user in Active directory and check the option "user must change password at next logon", the new user cannot logon and gets an "access denied" message. In /var/log/secure, I find the following:
Mar 1 14:43:21 cpssvn10 sshd[5363]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=192.168.3.12 user=testuser2 Mar 1 14:43:21 cpssvn10 sshd[5363]: pam_ldap: error trying to bind as user "CN=CPSS Testuser 2,OU=IBM,DC=cpss,DC=smarterplatform,DC=com" (Invalid credentials) Mar 1 14:43:23 cpssvn10 sshd[5363]: Failed password for testuser2 from 192.168.3.12 port 4583 ssh2
As soon as I uncheck the "user must change ..." option, the user can log on without problems. Also password change via the passwd command works.
I am running a mysql 5.0.41 community edition server.i have a user x and i need to set max connection limit for the user... Can any one give the correct syntax to update the current user to include max connection for the user x.
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 have been reading about asterisk, I did some basic configuration, a small ivr, record messages.. but I was wondering how and what/where should I modify to use a database to save sip users and voicemail user..then we can add user/voicemail with php-myadmin I always search but I cant find about this configuration..
Might this is silly question but I am not much familiar to database.I am doing master slave Mysql replication for load balancing. On master server different database has different user privileges. I create backup using mysqldump command and restore on slave server instead of using load data from master; command.When i replicate database from master to slave will i require to set user privileges same as master ?One more question: How to lock all database in mysql?
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
I installed mysql on FC14, but can't successfully create a new user. It lets me go through all the steps without complaint, but then I can't log into mysql as the new user.
Here's what I did.
1) yum install mysql mysql-server 2) service mysqld start ##sets up mysql 3) mysqladmin -u root password myownsecrectpass ##create a root password 3b) mysql -uroot -p; #log in as root, this works fine 4) CREATE DATABASE webdb; 5) CREATE USER 'anewuser'@'%' IDENTIFIED BY 'password123'; ##create anewuser with a passwd 6) GRANT ALL ON webdb.* TO anewuser@'%'; 7) FLUSH PRIVILEGES;
Then I log out of mysql as root and try to log in like this mysql -uanewuser -p
I enter the password and get this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
