Mysql "create and drop" permission problem

2007-04-24 Thread Cheng-Lin Yang
Dear all, I create a database called "test_aaa" to a user. And give him a permission to create and drop on this database. But I found he can create a database called "test-aaa" by his own. Can MySQL identify this problem? Also, can I limit user can only drop table in test_aaa but CAN NOT "drop dat

Re: Permission Problem in OS X

2004-01-23 Thread Brent Baisley
I'm not sure how much help I'll be since I have never had a problem running MySQL on OSX in the two years I have been using it on OSX. First, you should not need to use sudo or the root account for anything you do with MySQL except maybe installing it. Second, I would always specify the account

Permission Problem in OS X

2004-01-22 Thread Dietrich Speer
I am having a problem with accessing the mysql database in a new MySQL installation on OS X Panther. This installation came with the original OS, and some configuration was done right after installation. I have previously installed MySQL on Linux and Win and have never encountered this problem. A

permission problem

2003-06-03 Thread PaT!
Hi, I'm using MySQL 4.0.13 OS Windows 2000 server SP3 I have the following problem: I had a local user that used regularly to access with winmysqladmin User name and no password Now it can access from the shell but can't from winmysqladmin anymore. Don't know why, I think I didn't change anythin

mysql permission problem

2002-08-12 Thread Kaming
Hi all, I am using mysql version 3.23.47 on RedHat linux 7.2. I found that the permission I have granted before, for example, login the mysql server and execute 'grant select on *.* to [EMAIL PROTECTED] identified by "test"; flush privileges'. Then I can access to the mysql server from the cl

RE: Permission problem

2001-11-13 Thread Harpreet
MAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:26 PM To: 'MySQL Mailing list' Subject: Permission problem I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every

Permission problem

2001-11-13 Thread Harpreet
I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every other database. After creating this new database now when i try to type in USE MYSQL, it changes to the mysql database . An

Re: Permission problem

2001-10-01 Thread Benjamin Pflugmann
Hi. Sorry, but how does this problem relate to MySQL? Bye, Benjamin. On Mon, Oct 01, 2001 at 11:29:13AM -0400, [EMAIL PROTECTED] wrote: > Hello list members, > > I am running mysql on a linux server. I can connect to it using telnet and > also using mysql client. I am given all the p

FW: Permission problem

2001-10-01 Thread Harpreet
t: Re: Permission problem I got similiar problem before.The reason that I got "permission denied" is I did not have the right to transfer file to a specific folder. >>> "Harpreet" <[EMAIL PROTECTED]> 10/01/01 10:29AM >>> Hello list members, I am runn

Permission problem

2001-10-01 Thread Harpreet
Hello list members, I am running mysql on a linux server. I can connect to it using telnet and also using mysql client. I am given all the permissions. I am trying to create a few php pages and want to ftp them to the linux server . I am using WS_FTP. i can view the folder where i need to put th

RE: (anonther) user permission problem -- hit "send" to fast

2001-06-21 Thread Lancashire, Pete
Forgot to add Can connect from a different host by using both the hostname and FQN, For example the name of the host with the mysql server is sparky. >From sparky -h localhost -h sparky -h [EMAIL PROTECTED] All fail >From another host both sparky and [EMAIL PROTECTED] let me in, and Of cours

(anonther) user permission problem

2001-06-21 Thread Lancashire, Pete
Hi fellow mysql'ers Here my "simple" problem I can connect to the mysql server host from any other host, but I cannot from the host with the mysql server. More detail Mysql 3.23.30-gamma (yea I know I need to update it) Example user is foo, password is bar Columns_priv, func, and host are em

Unable to start mysqld due to permission problem

2001-02-20 Thread mette
>Description: I followed the installation steps as provided at: www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary When I ran 'bin/safe_mysqld --user=mysqld &' mysqld would not start. When I did an ls -l, here's what I got: lrwxrwxrwx 1 mysqlroot