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


ADVERTISEMENT

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

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

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

OpenSUSE Network :: MySQL Create User/permissions?

Jan 13, 2010

MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?

View 7 Replies View Related

Ubuntu Servers :: FTP Server With Gui Frontend For User Administration

Mar 18, 2011

I want to make a FTP server with web frontend for administering it, eg creating users, groups, setting which directories users can access and so on.I found some web frontends for proFTPd, like those URL... , bus all of them seems to be very old and doesn't work nicely. I tried ProFTP Administrator and it won't work.Do you know some solutions to manage ftp server users, groups, permissions over web? Or by some frontend program.

View 2 Replies View Related

Ubuntu :: Add Root Permissions To User?

Jun 5, 2010

How do I add root permissions to my user account?

I want full permissions for all computers in my house, without having to get up and go to the other room and change permissions for the file, then go back to the other room again.

I just created a partition, as THIS user, THIS machine, rebooted, and cannot create a folder on the partition I just created. UGH. No more of this stuff...

View 4 Replies View Related

Security :: Add Root Permissions To User ?

Jun 5, 2010

How do I add root permissions to my user account?

I want full permissions for all computers in my house, without having to get up and go to the other room and change permissions for the file, folder, drive, directory, computer, etc., then go back to the other room again.

I just created a partition, as THIS user, THIS machine, rebooted, and cannot create a folder on the partition I just created. UGH. No more of this stuff... I guess at the very least, I'll still have to log onto each machine for this?

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

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

[code]...

View 13 Replies View Related

OpenSUSE Hardware :: Changing Permissions From Root To User

Jun 6, 2010

I recently got a new external drive and backed all my files up on the new external: movies, music, docs, etc. Now all my files have permission rights to the root only. I was able to change this by open up nautilis from a terminal in root and change the permission on the whole drive to my current user so I can access the files, copy & delete the files. I wanted to change some music file information in Kynamo this morning and was not able to since all the individual files still belong to the root. How can I change this permission issue without having to change each individual file?

View 8 Replies View Related

Ubuntu :: Chmod File Permissions Between User And Root ?

Jan 26, 2011

I want to have two kind of users in a work machine having ubuntu 10.04,

1) He is the admin, have sudo privilages and install, do all types of work, his username is abhilash

2) A user who is normally a IT administrator, who can just install or remove softwares, but cannot access files of abhilash.

I'm trying to do this and my head is going blank, The problem where i'm stuck is, if IT admin can install softwares, then he can become sudo as sudo su, then he can view my files

So here is a small test i did, first with abhilash.

Code:

Now others and group don't have any permissions! But when IT Administrator becomes root, he can see this file

Code:

View 5 Replies View Related

General :: Unable To Change The User And Root Permissions?

Mar 23, 2011

I was unable to change the permissions for root node and for other users also. WE have tried all the possibilities like chmod and chmod -R 777 filenem. But we are unable to change that.

View 4 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

General :: Setting Read Permissions Of A Directory For Root User Only?

Mar 21, 2010

I'm using ubuntu 9.10. I used the command:

root@aduait-laptop:~# sudo chown -R root:root /media/104B-FF96/Private to set the permissions of Private folder for root but it is giving error:

Code:
root@aduait-laptop:~# sudo chown -R root:root /media/104B-FF96/Private
chown: changing ownership of `/media/104B-FF96/Private/5.jpg': Operation not permitted
chown: changing ownership of `/media/104B-FF96/Private/6.jpg': Operation not permitted
chown: changing ownership of `/media/104B-FF96/Private/7.jpg': Operation not permitted

[Code].....

View 5 Replies View Related

Debian :: Default Ownership Of Folders And Files - Should Own By A User Without Root Permissions

Feb 12, 2011

Being new to Linux, i've just about got used to the Debian setup procedure now, but had a quick question on the default ownership of files and folders. On my default Debian installation, almost all the folders and files are owned by root:root. Is this the correct advised configuration or should the folders and files be owned by a user without root permissions - eg user:user?

View 12 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:Thisis needed for cookie based authentication to encrypt password incookie

View 2 Replies View Related

Ubuntu Servers :: Administrator User Id Doesn't Seem To Have Root Permissions To Create Directories?

Mar 30, 2010

Need help maintaining permissions across multiple directories. Have Ubuntu 8.04 Hardy Heron. O/S installed, updated and running with no problems.Why is it that my administrator user id doesn't seem to have root permissions to create directories? I am trying to setup hosting 3 separate websites and therefore create 3 separate directories to manage all associated files for the 3 websites. Also, I am attempting to read through the tutorials located at:URL...

View 4 Replies View Related

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 View Related

Server :: MySQL Permissions - Copy Tables From One DB To Another

Jun 14, 2010

I am using Joomla and a script within it. That Script is suppose to copy tables from one DB to another.

Code:
Error(1) [1142] query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
Error [1142] retrying query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
localiz_master: name of the DB from which data is suppose to be copied.
jos_users: name of the table form the main DB.
localiz_master: user for the DB.
localhost: host
test_users: name of the table to be created.

We do have phpmyadmin but the user's table is hidden. What SSH command we might run to make localiz_master user have access to all the databases.

View 6 Replies View Related

Server :: User Folder Permissions For FTP?

May 4, 2010

I want to host a public FTP on my server, but i cannot get it so that people can read and write but not delete ANYTHING from it.
I have tried:

chown root /home/ftpdir
chmod 1777 /home/ftpdir

but people can still delete the files in it, i have no idea what to do next. that's the only thing i can find on Google about how to do it.

the users are logging in with the same Account, i cannot make a new account for each one.

View 1 Replies View Related

Server :: Mysql-server Root Connects, No Other Account Does?

Jul 17, 2011

I'm running Debian Testing and am confounded by a new problem.mysql -u root -p works great.mysql -u mythtv -p doesn't. This is a first for me.I did the usual as mysql root: mysql> create user 'mythtv'@'127.0.0.1' identified by 'mythtv';Query OK, 0 rows affected (0.01 sec)

mysql> grant all on *.* to 'mythtv'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;

[code]....

View 2 Replies View Related

Server :: Creating Ftp User In Centos With Permissions?

Jul 12, 2011

I have created a ftp user in centos 5,but it got all permissions to delete files in other location,view the entire directory and create any folder in every place. How to deny this permissions to the particular user.And please help me to give permissions only to a specified location given by the root.

View 4 Replies View Related

Server :: How To Reset Root Password Of MySQL?

Sep 21, 2010

for resetting the root user's password. Actually, I am using www.linuxzoo.net for online practice of Linux and have MySQL installed on it. But I forgot the password I set. There was no password by default set for the root user. So, I just trying setting a password last week. Now I am not getting what I did.

View 13 Replies View Related

Server :: MySQL - Remote Access For Root?

Aug 9, 2010

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?

View 3 Replies View Related

Ubuntu Security :: Anyway To Get Nautilus To Give Root Permissions On Server?

Mar 30, 2010

I have recently secured a server by preventing root from logging in via SSH. Now I log in with a non-root account and use 'su' when necessary.However, now I can't do something I used to do, which is open 'sftp://user@ipaddress' in nautilus and be able to edit files as root. Is there anyway to get nautilus to give me root permissions on the server? Or at least end up with root permissions in a GUI text editor on my computer? I don't mind if I have to use bash to start the process, once I can get a GUI for editing files.

Note 1: Yes, I realize I could ssh in and use nano/vi etc, but I'd rather use my graphical text editor.
Note 2: The server does not run X, so I can't just forward it.

View 1 Replies View Related

Ubuntu Networking :: Samba Server And User Permissions

Dec 30, 2010

I have a Samba server running on a box where I login to admin as user:
FRED
The Samba users are
SUE
JOE - Read only for specified paths (media playback access only user)
SUE can read/write to any directory under the share: Media

So all that is working fine. As long as I do file operations remotely as SUE everything works remotely. How can I make it to where everything SUE does over Samba FRED automatically has permissions to edit when logged in locally (or SSH)? Also, remember, Joe needs to be able to read where specified.

View 3 Replies View Related

CentOS 5 Server :: Setting User Permissions In NFSD

May 19, 2009

I am currently trying to replace my Windows Server with a CentOS 5.3 box running nfsd for file serving. I have it all up and running however I cant see anyway of securing user access rights to the shares as all you need to access them is just clone the User ID of a user authorized to access the share of any Linux system which seems a bit insecure to me? I was wondering if there was any advice on securing access to server shares in CentOS.

View 2 Replies View Related

General :: Non-Root Portable Install Of MySQL Server?

Mar 3, 2010

Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.

View 2 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







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