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