Software :: MySQL Initial User Logon ID?

Aug 11, 2009

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?

View 5 Replies


Ubuntu Installation :: Reboots After Initial Logon?

Feb 17, 2010

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.

View 1 Replies View Related

Ubuntu :: Mysql Errors Can't Logon As Root?

Jan 11, 2010

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

View 2 Replies View Related

Ubuntu :: What Privileges Does Initial User Have?

May 16, 2010

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...

View 6 Replies View Related

Security :: Allow User To Logon Remotely Using SSH?

Feb 10, 2010

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).

View 1 Replies View Related

Fedora :: 14 - Logon Screen User Order ?

Nov 4, 2010

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?

View 5 Replies View Related

Ubuntu Security :: See History Of User Logon's

Aug 6, 2010

I think someone hacked my server and I'm wondering if it's possible to view the possible the past user logons?

View 6 Replies View Related

General :: Logon User - Unable To Get Property

Jul 14, 2010

I'm working on a script notifying me after a client changes a log level on a given server. I get the following error after running the script:

LogonUser [
odeunivmo3domaincommon]: unable to get property
LogonPassword [
odeunivmo3domaincommon]: unable to get property

I get the email notification fine, the environment is set to common. I think the problem is somewhere in these lines of code.

SCP_USER=`${cer_exe}/lreg -getp \
ode\\${NODE}\domain\\${loc_env} LogonUser`
SCP_PSWD=`${cer_exe}/lreg -getp \
ode\\${NODE}\domain\\${loc_env} LogonPassword`

View 3 Replies View Related

General :: Restrict A Single User Logon?

Jun 9, 2010

how can i restrict a single particular user from logging into the server not more than 5 times?

The conditions may be:

1) wrong password

2) can login only 5 times on one day etc.

View 5 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

CentOS 5 :: Initial KDE Desktop Settings On An Existing User?

Aug 30, 2009

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?

View 3 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

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

GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:


View 13 Replies View Related

Fedora :: Exclude - Hide A User From GDM Logon Window

May 31, 2010

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>)

When Fedora could have a gdm config again?

View 5 Replies View Related

OpenSUSE Install :: Empty User List Pre-logon

Dec 14, 2009

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..

View 4 Replies View Related

Red Hat / Fedora :: Logon Failure: Unknown User Name Or Bad Password

Jun 20, 2011

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: \ 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.

View 2 Replies View Related

General :: Unable To Logon To RHEL5.5 Locally As A User?

Feb 15, 2011

logon to my RHEL as a user. I am able to logon in as root locally.

View 3 Replies View Related

CentOS 5 :: Launch Bash Script On User Logon?

Nov 12, 2010

What is the best way to lauch bash script on user logon and logoff?

View 1 Replies View Related

Server :: Vsftpd Chroot Mode When User Logon First Time ?

Jun 22, 2011

I've config vsftpd chroot mode follow:



View 4 Replies View Related

Security :: Display Of Number Of Failed Logon Attempt At Logon?

Jan 26, 2010

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.

View 5 Replies View Related

Security :: Getting Access Denied When "user Must Change Password At Next Logon" Is Checked?

Mar 1, 2011

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= 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 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.

View 2 Replies View Related

Fedora :: Creating User For Mysql?

May 21, 2010

I am having fedora 12 with php and mysql rpms installed on my computer.. but I am unable to log in...nether create an user?

View 3 Replies View Related

Fedora Servers :: MYSQL MAX Connection Per User

Sep 28, 2009

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.

View 1 Replies View Related

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:

> mysql -b -u MY_user -p
Enter password:


View 6 Replies View Related

General :: Backing Up /var/lib/mysql As Non-root User?

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

Server :: Asterisk User Andvoicemails With Mysql?

Jun 1, 2010

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..

View 1 Replies View Related

Server :: Does The Mysql User Need Bash Shell

Oct 2, 2010

Is there any reason for the mysql user to need bash shell?

From /etc/passwd:

mysql:x:100:103:MySQL server:/var/lib/mysql:/bin/bash

Will anything break if I change that to /bin/false?

View 2 Replies View Related

Server :: User Privileges In Mysql Replication

Sep 27, 2010

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?

View 2 Replies View Related

Programming :: Create A User For Php/MySQL Under Ms Win Environment?

Jun 30, 2010

create a user for php/MySQL under ms win environment?

View 1 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

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:

the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/': No such file or directory


View 6 Replies View Related

Fedora Installation :: Mysql Fc14 Can't Create New User?

Nov 10, 2010

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
5) CREATE USER 'anewuser'@'%' IDENTIFIED BY 'password123'; ##create anewuser with a passwd
6) GRANT ALL ON webdb.* TO anewuser@'%';

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)

View 3 Replies View Related

Copyrights 2005-15, All rights reserved