Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

FreeBSD Ports and Packages Installation and upgrading of ports and packages on FreeBSD.

Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   (View Single Post)  
Old 13th December 2008
Mantazz Mantazz is offline
Shell Scout
Join Date: Oct 2008
Posts: 90
Default MySQL permission oddity

I have MySQL running on my FBSD box at home, finally. I decided to make a small database for analyzing /var/log/messages, as my system has been under an interested distributed hack attempt lately and I wanted to see if it would actually be useful to try blacklisting the addresses (sometimes over 200 different addresses attempting ssh connections in one day).

To make a long story less long, I made a database "hackers", with one table "attempts". This table has three columns "time_id", "IP_address", and "faileduser_id".

If I connect to the database as root, I can see the table and columns correctly. Obviously this is not a good practice so I then made a database account "syslog" and gave it permissions accordingly:
grant all on hackers to syslog@localhost identified by 'PASSWORD';
where of course PASSWORD is replaced by my awesome, secure password.

So then I connect to the database as syslog:
> mysql -u syslog -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
And connect to the database and look for tables:
mysql> connect hackers;
Current database: hackers

mysql> show tables in hackers;
Empty set (0.00 sec)
Any MySQL guys out there who might know what is going on here? As I said, the user root on the same MySQL instance can see the tables just fine.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission problems after restore Crotalus FreeBSD Installation and Upgrading 3 5th February 2009 02:17 PM
FFS permission issue marc OpenBSD General 2 2nd February 2009 07:31 PM
Permission denied (publickey). Help pls rex FreeBSD General 13 14th October 2008 08:54 PM
user permission... lumiwa FreeBSD General 12 30th September 2008 02:28 AM
Permission denied delboy FreeBSD Ports and Packages 11 24th May 2008 09:26 PM

All times are GMT. The time now is 10:12 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick