Ubuntu :: Completely Remove MySQL - Root User Loosing Privileges

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


ADVERTISEMENT

OpenSUSE Install :: Get Root Privileges On User Account Without Using Root Login?

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

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

General :: Remove All Privileges From A Particular User?

Aug 5, 2011

I need to create a user in Fedora Linux(15) which only has privileges to print documents.Our college issues a printer to each lab and I need to create a new user on my Fedora which only has privileges to print.Network sharing is not an option, so is there any way by which I can a restrict a user from executing any commands except the necessary printing commands?

View 2 Replies View Related

Ubuntu :: Way To Grant 'root' Privileges To User Account?

Jan 2, 2010

Is there a way to grant 'root' privileges to my user account? My account name ... I'll call it 'masterskop' as it is my forum name here, but not on my computer.Would it look like this in the sudoers' file?My purpose is to get access to all the folders and files in the 'File System'. The root and lost+found folders have 'Xs' on them...No access! And for example, under properties of the 'var' folder it states that 'you are not the owner, so you cannot change these permissions.' How can I get access to all of it everytime I login as the main user of my computer? I do not have anyone else using this computer.I did edit this file and used my real user name ... logged out and logged back in and still I do not have access/edit these folders and files.

View 4 Replies View Related

Ubuntu :: Give The Live User Root Privileges?

Feb 26, 2011

i am trying to recover some files on a partition through the ubuntu live cd (they are hidden files and i can't find anything else that would work) and it said i needed root privaleges in order to copy them. is this possible and how do i do it

View 8 Replies View Related

General :: Create The User With Root Privileges?

Jul 4, 2010

I want to create a user who has all the privileges that root user has.I know how to create a user but i don't know how to grant root privileges to him.

View 10 Replies View Related

General :: Add User With Root Privileges And SSH Access

Nov 2, 2010

How to add user with root privileges and SSH access.

View 6 Replies View Related

General :: Create A User Without Root Privileges?

Apr 9, 2011

I create a user in CentOS 5.5 for using with my email account.

useradd ralf
passwd ralf

use "ralf user" only for my email account. How can I remove others privileges/permissions? Also, I want to use "ralf user" without root privileges/permissions.

View 4 Replies View Related

General :: User Access To Commands Having Root Privileges?

Oct 14, 2009

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.

View 8 Replies View Related

General :: Create User Similar To Root Privileges?

Feb 20, 2010

i do need to create 1 user who has similar to root privileges but the username will not be root.

View 13 Replies View Related

OpenSUSE Network :: Starting Apache As A User With Root Privileges?

Jul 17, 2010

I have written a simple perl program to add a command to iptables. Here is my code :

Code:
#! /usr/bin/perl
print "Content-type: text/html
";
system("iptables -A FORWARD -s 192.168.0.2 -j DROP");

I put this file in cgi-bin folder of Apache server. Here is my problem : when I run this file with shell as root user it makes change to iptables, but when I use my browser to run this file, it doesn't make any change. I'm sure this is because Apache doesn't have permission to manipulate iptables. How can I start Apache as a user with root privileges ?

View 8 Replies View Related

Ubuntu Security :: Actions Requiring Root Privileges Asks For Wrong User ?

May 24, 2011

In our group we use NIS and have a group set up called netadmin which is given root privileges on each machine. Each machine also has a localuser called localuser created and used during installation. When logged in as a member of netadmin, attempting any action that requires root privileges (e.g. installing software in Ubuntu Software Center) results in a prompt asking for localuser's password, not the current user's password.

Does anyone know the cause? Configuration issue or Ubuntu issue? We can get around it.

View 2 Replies View Related

Fedora Networking :: Connecting Wired Connection 15 - SWITCH TO ROOT USER If Don't Have Privileges

May 26, 2011

Figured out a straight shot at connecting to the Internet in Fedora 15. Follow these commands.

1.)****** SWITCH TO ROOT USER if you don't have privileges*******
2.) cd /etc/sysconfig/network-scripts
3.) rm ifcfg-XXXXX (DO NOT REMOVE THE IFCFG-LO)
4.) system-config-network

-> Once in this screen, press the enter key on "Device configuration"
-> Configure your network statically. ( I did the following.) Name: leave as default Device: Leave as default DESELECT "Use DHCP" Set Static IP as 192.168.2.117 (or 192.168.1.117) Set NetMask as 255.255.255.0 Set "Default Gateway IP" AND "Primary DNS Server" to 192.168.2.1 (or 192.168.1.1)

[Code]..

View 4 Replies View Related

Security :: How Secure To Grant "reload" Privileges To A Normal User In MySql

Oct 15, 2010

One user in my company wants to run some flush cache queries on a MySql database, it needs "reload" privileges of Administration, how secure is to give this rights to a normal user ?

View 2 Replies View Related

Software :: Remove The Root Password In Mysql?

May 28, 2010

is there any way to remove the root password in mysql,if can what is the command to remove it.

View 3 Replies View Related

General :: Give Domain Administrator Privileges To Root User In Domain Controller?

Aug 17, 2009

I want to give Administrator privileges to Root user in Linux Domain Controller

View 12 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:

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

[code]....

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 :: MySQL Root User - Administration And Permissions

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

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

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

Debian :: MySQL: #1045 - Access Denied For User 'root'?

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:Thisisneededforcookiebasedauthenticationtoencryptpasswordincookie

View 2 Replies View Related

Server :: Changed Root User Access For MySQL To Any From Localhost?

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

Security :: Secure FTP - Root Privileges After Logging In Form A Macintosh And Could Browse The Root Directory

Apr 12, 2010

I run ProFTPd with TLS authentication on my Debian Lenny server. My problem is that despite of the fact that my users connect chrooted, one of my friends had root privileges after logging in form a Macintosh and could browse the root directory, too.

View 1 Replies View Related

Ubuntu Servers :: Setup The MYSQL Server - Error: 'Access Denied For User 'root'@'localhost' (using Password: NO)'

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

Ubuntu :: User Settings User Privileges

Aug 11, 2010

This applies to users of 10.04 (64 bit), but I would like to hear from those running 10.04 (32 bit) and 9.10 (64 or 32 bit).Would you be good enough to answer this question: Do you have an �enable scanner option� (or a variation of that phrase) in (GOTO) System-Administration-Users & Groups- [Your Admin Account]- Advanced Settings- User Privileges?It would be immensely helpful of you if you could do this and post me your answer.

View 2 Replies View Related

Ubuntu Security :: Remove All Privileges From CWD?

Jan 21, 2010

I am on the admin account of my computer and am trying to remove all privileges from CWD i have tried

chmod go-rwx ~
sudo chmod go-rwx ~

but when i pull up

ls -l ~

It is still showing permission in the g and o column.

View 9 Replies View Related

Ubuntu :: USB Needing Root Privileges?

Apr 4, 2010

We formatted a USB stick to EXT3 for use on a linux formatted device.Now, when we try and transfer files from this ubuntu laptop onto the USB stick, it says permission denied.

View 4 Replies View Related

Ubuntu :: Shutdown PC Without Root Privileges?

Sep 6, 2010

All of as now the add-to-panel item that via it you can shutdown the PC without the need of typing any password to gain root privileges.

How is this possible? I know that fro default the login screen is run by root but how do this app sends the signal to the login-screen to shutdown?
I mean, this app is run without root privileges by me, the simple user, and when clicked the PC shutdowns via a signal from this app to the login screen....
How can I call this signal to an app of mine?

View 9 Replies View Related

Ubuntu :: Give Only Certain Root Privileges?

May 29, 2009

We have Ubuntu 8.0.4. We'd like to give this one user the ability to reboot the server but no other root privileges. I'm assuming this can be done using sudo. What file and what change do I need to make to it?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved