Programming :: MySQL Security - Remove The Ability To Make Test Databases?
Sep 29, 2010
I know very little about MySQL, but I've got some users that need it for testing on a Linux server.So I had set it up a while back, but now I'm running into some small problems.Right now, each user has his own database that I created and can do whatever with it. Each user only sees their own database.I didn't want them to be able to create new databases at all, but they can and when they do anyone can see them.
EDIT(Apparently they can only create databases beginning with the word "test" in the name)
I need to either:
1) Stop them from creating new databases (without affecting their ability to interact with the existing database)
OR
2) Make it so that when they create a database, only they have privileges on it and only they can see it (except mysql root of course).
Anybody know the statement to set these kinds privileges up?
EDIT: pfft... I've a read a bit more and realize that this is an intended part of the installation.
EDIT2
I'd still like to remove the ability to make test databases.
EDIT3:Ok, for reference this is how you prevent users from making and using test databases:
shell> mysql -u root -p
Enter password: (enter root password here)
mysql> DELETE FROM mysql.db WHERE Db LIKE 'test%';
mysql> FLUSH PRIVILEGES;
View 4 Replies
ADVERTISEMENT
Apr 15, 2011
I've been reading a lot of articles on Xorg XWindow System having the ability to allow 6600/tcp for remote screen connections and I've been trying to find a way to remove the functionality without having to just dump XWindow and settle for CLI on my server. I heard it was disabled by default, but I just want to get rid of that ability completely by cutting it out of it's code and yes, I'm feeling very, very paranoid.
View 2 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
Jan 20, 2010
I use a version of Ubuntu Desktop Edition 9.04 and installed various server software useful for my needs.
New issue. How do I get MySQL databases working on this system, and how do I get myPhpAdmin to help manipulate said databases onto the system?
View 7 Replies
View Related
Mar 25, 2010
I need to move mysql databases from my hard drive which is currently in external box. I can't boot the drive since the laptop is down. Nothing of the distribution on the drive is missing. I just need to know which files/folders copy to my new computer to have all databases running. Old computer ran on Dreamlinux (Debian-based). I'm currently running Ubuntu 9.10.
View 5 Replies
View Related
Mar 23, 2010
I have installed mysql ,php ,apache,phpmyadmin i have create a forum on mysite check it on[URL]..Now i have create a database with name login and then i create a table with name loginn ..After that in loginn table i create colums with name username (data type=varchar),and password(data type=int);i want when someone entered username and password in my sql ,it goes to database and userconnect to next page as we generally do in orkut or other social sites;I dont know how to connect with php with mysql and how to do it whole
View 3 Replies
View Related
Mar 15, 2010
I am trying to install mysql 5.1.44..so i downloaded the binary package, i extracted it and then followed the instructions that were in the manual but i keep getting this error when running this command
Code:
scripts/mysql_install_db --basedir=/home/mosty/mysql
the error is
Code:
Installing MySQL system tables...
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
[code]....
You can try to start the mysqld daemon with:
shell> /home/mosty/mysql/bin/mysqld --skip-grant &
and use the command line tool /home/mosty/mysql/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /home/mosty/mysql/bin/mysql -u root mysql
mysql> show tables
View 1 Replies
View Related
Aug 12, 2010
Quick searches did not bring forth any standard solution.
I have installed Ubuntu Server 10 (x64) using LVM with two disks (this is a Virtual Machine on VMWare ESXi4)
During install I selected only disk 1, and LVM guided Installation Added LAMP and SSH
Server gives only a text mode configuration, great if you are a linux guru, but I am not so it took a bit to find a stripped down GUI. None could be found but I did the following:
apt-get install xorg gdm gnome-core (minimal Gnome install)
apt-get install gnome-system-tools (users and *****s, time)
apt-get install gnome-network-admin (network config)
apt-get install update-notifier (updates)
[Code].....
I have created a similar system with Ubuntu, now I wish to move the var/www directory to sda1, and the databases from MySQL.
View 8 Replies
View Related
Sep 18, 2010
Trying to set up a backup for mySQL databases in CRON.
I've entered the following line in /etc/crontab:
Code:
7 13 * * * root mysqldump -u root -pMYPASSWORD --all-databases | gzip > /home/myuser/mysql_backups/database_`date '+%Y-%m-%d'`.sql.gz
grep CRON /var/log/syslog shows:
[Code].....
If I run the command outside of CRON, it creates the backups no problem, but CRON is not doing anything.
View 3 Replies
View Related
Mar 8, 2011
I have a laptop and a desktop PC, both running Ubuntu 10.04 and both are configured the same way. I am using Unison-gtk to sync the data between both computers... This works for everything... except for my mysql databases. Any way to simply sync my mysql databases on both computers. Right now I need to do this table-per-table... and it is quite long to proceed like this. What I need is a script or a program (open and preferably free) that would just compare both databases (all the tables) and sync them either by updating existing tables or by creating them. This should work both ways... obviously. I could write a script for this, but I am sure there already is something for this out there.
View 9 Replies
View Related
Mar 9, 2010
I have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
View 1 Replies
View Related
Jun 8, 2010
How do I restore MySQL Databases from an old hdd with Ubuntu on it which won't boot? Information below is not necessary just explaining how I ended up in this situation. Today the harddrive crashed on one of my development servers and I have no recent backup of the MySQL databases on the server.
The stuff on the server weren't horrible important but it would still be nice if I were able to recover some of the files. This is the thing, I don't think the harddrive is entirely dead because it comes to a screen saying harddrive error something enter to continue then it says GRUB in the upper left corner before the computer crashes/reboots.
So I installed Ubuntu server on a new HDD and now I want to attempt to recover the databases from the old HDD by mounting it in Ubuntu but before trying I would like to know who one does that. As I've understood it's a bit more complicated then one might thing because MySQL uses binaries and not plain-files.
View 2 Replies
View Related
Feb 15, 2011
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
View 6 Replies
View Related
Jun 6, 2010
I am trying to make a simple vector test program, but i can't compile it. Here is the code:
Code:
import java.util.*;
class Vec {
public static void main(String args [ ]) {
[Code]....
View 2 Replies
View Related
Aug 2, 2011
Rebooted my server after some funky stuff started happening with mysql. Turns out the drive that stores the mysql databases has gone missing. I did an fdisk, and the partition table is gone. I used gpart to see if there were any partitions available & there were -- two + one swap. Can you help me put this back together I know very little about reconstructing a table to use... Here is the output of what I've talked about...
b14:~# fdisk -l
Disk /dev/sda: 164.6 GB, 164696555520 bytes
255 heads, 63 sectors/track, 20023 cylinders
[code]....
View 1 Replies
View Related
Aug 7, 2010
how can I display all databases and their size using command lines (linux) in a mysql server?
View 3 Replies
View Related
Jun 10, 2011
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
View 1 Replies
View Related
Aug 24, 2010
I know PHP auto removes stale sessions on it's own, but that doesn't remove them from the MYSQL table. So I was gonna make a cron script that ran once every hour that removed any MYSQL shopping cart item from the table if the original session_id that created it does not exist anymore.
From my understanding a session_id is an "actual" file located somewhere on the harddisk (is it not? correct me if I'm wrong), so I was going to do a simple check for each item in the shopping cart to check for it's original session file, if it didn't exist on the harddisk, then simply remove it from the mysql table.
View 1 Replies
View Related
Nov 18, 2010
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.
View 6 Replies
View Related
Sep 21, 2010
I transfered some mysql databases from an 8.04 partition to a 10.04 partition. They wouldn't open because the ownership & group was root:root since I transfered them as root. I looked at the original ownership of the files on 8.04 & found they were all "sane:124 ". I changed everything to mysql:mysql on the 10.04 partition & everything works O.K. now but I have no idea where that owner & group came from.
Two things I don't understand:
1 -Why I had to change ownership from root:root when I was logged in as root in mysql & the databases didn't show up?
2 - Where did the original "sane:124" ownership come from?
View 1 Replies
View Related
Mar 9, 2011
I decided to consult you before making any changes, because the clients' PCs are spread all over the country and I do not have the physical access to their boxes.The idea is to take away the ability of using sudo for common users.I know that the syntax of this file may vary a bit in different distributions.Our OS is Ubuntu 10.10.I created the account 'support' for me and other technician stuff of our department. So, 'support' user must have all the power. And common users mustn't have access to 'sudo'. This is the requirement.As far as I remember, in Slackware the user must be a member of 'wheel' group to be able to use 'sudo' (but I may be wrong).
View 3 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
May 18, 2011
A create an application which has to bind to port less than 1024 and must be launched under non-root user. OS: Ubuntu 10.04. Decision 1: Using a firewall to redirect packets. Problem: This decision is not good for me. I need simple way to solve the problem. Decision 2: Use CAP_NET_BIN_SERVICE. Problem: My execution file has 2,7G size. It is very big application with a lot of debug info. setcat command return an error:
[code]...
View 1 Replies
View Related
Sep 26, 2010
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
View 9 Replies
View Related
Feb 8, 2011
So, I am looking to implement an FTP server with Isolated Client accounts/directories where a client can only access what's in their directory. I also need to provide my internal user's (content managers) the ability to upload, delete, etc from all of the Client accounts. The simple part is creating the secure client accounts. It's a matter of changing DIR_MODE in adduser.conf to 700 or 770, creating a user, having the FTP server chroot them to their home directory, revoke/restrict shell/ssh access and maybe even slap on some ACL to prevent botched permissions.The hard part is figuring out how to give my power users the ability to access all of their folders without thrashing security.
My first thought was to put all of the client user-groups in a parent group and having my internal users inherit group permissions..but you can't have groups inside of groups.My second thought was to put all of the client users in the same group and prey that the FTP chroot is enough to keep them from poking around but then I have the problem of how do my internal users access other user directories if they are chrooted. Do I create a second server without chroot.do I create some weird nested homedir structure..I honestly have no idea how to satisfy both requirements (secure client accounts and privileged user accounts). I need my privileged users to authenticate against Active Directory via Likewise open, LDAP, etc and I don't care how the clients authenticate. Though, I would prefer to have both file and FTP-server level protection just to make sure no one can see the other client's data.
View 1 Replies
View Related
Aug 6, 2010
would this script not work?
Code:
#!/usr/bin/perl
#PERL module
use Mysql;
#CONFIG VARIABLES
[Code].....
I clearly have a lot to learn, but I have done about 10 Google searches trying to find out how to test connectivity b/t mod_perl and mysql.. maybe I'm confused on how this works.
I have this in httpd.conf
Code:
Perlrequire /etc/httpd/conf/perl-startup.pl
PerlWarn On
PerlModule Apache::DBI
I have this in perl-startup.pl
[Code]....
View 4 Replies
View Related
Feb 15, 2011
I want to know how can I test my server security with hping3 tool I want to make a virtual DoS or DDoS or SYNK attack in my LAN to test my server security and ability against these attack .Is hping3 a good solution for this or not if yes how can I do this which option of this can make such these attacks?
View 4 Replies
View Related
Feb 8, 2010
mysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
View 1 Replies
View Related
Jul 8, 2010
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
View 2 Replies
View Related
Jun 21, 2010
I am the only user on my laptop so there are somethings that I don't need.I would like to remove the login at start. What do I remove to make it go away? Second one is Keyring. Is it necessary? Can I remove it without causing problems?
View 8 Replies
View Related