Re: access problem for a particular table

2014-06-03 Thread Divesh Kamra
Hi Run mysql_upgrade command at OS shell DK Sent from Phone > On 28-May-2014, at 1:40 pm, "Lentes, Bernd" > wrote: > > Hi, > > we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't > access one particular table. > Automysqlback 3.0 says: mysqldump: Got error: 1142: SE

Re: access problem for a particular table

2014-05-28 Thread Johan De Meersman
- Original Message - > From: "Bernd Lentes" > To: mysql@lists.mysql.com > Sent: Wednesday, 28 May, 2014 10:10:33 AM > Subject: access problem for a particular table > > we just migrated from 5.0 to 5.5. Nearly everything went well. But we can

access problem for a particular table

2014-05-28 Thread Lentes, Bernd
Hi, we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't access one particular table. Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'backup'@'localhost' for table 'cond_instances' when using LOCK TABLES. root has these rights

Re: access problem

2004-05-17 Thread Egor Egorov
Jianping Zhu <[EMAIL PROTECTED]> wrote: > > > I have database Zope > I run following command and get error > > > myql> grant all on Zope.* to [EMAIL PROTECTED]; > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'Zope' > mysql> > > As a consequece I try to access Zope from a

access problem

2004-05-14 Thread Jianping Zhu
I have database Zope I run following command and get error myql> grant all on Zope.* to [EMAIL PROTECTED]; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'Zope' mysql> As a consequece I try to access Zope from a web, it also shows me the error. how can i fix this problem?

myodbc - ms-access problem: table contents not shown

2004-04-06 Thread Mike Bosschaert
show up in the table-view. This may as well be a generic ms-access problem or a codeweavers bug, but I can't find the anwer. Is there anyone on this list who known how to solve the problem? Thanks in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql

RE: MySQL and PHPBB access problem

2004-03-31 Thread Dathan Vance Pattishall
31, 2004 11:09 AM > To: [EMAIL PROTECTED] > Subject: MySQL and PHPBB access problem > > Hope you guys can help a n00b, although I just got my MCSA. I have a > server at my home network behind a router/switch. It's running Server2000 > SP4. IIS is installed from the CD itself

MySQL and PHPBB access problem

2004-03-31 Thread vze1tvxm
Hope you guys can help a n00b, although I just got my MCSA. I have a server at my home network behind a router/switch. It's running Server2000 SP4. IIS is installed from the CD itself. I already have an ftp running for practice. That went well. I found phpbb 2.0.8 and downloaded it. I didn't ins

remote and local access problem

2003-11-11 Thread Jan Emmer
I have MySQL 3.23.52 server running on 192.168.1.1. This behavior seems to be strange for me: In mysql client runned on 192.168.1.1 I set these commands: CREATE DATABASE pokus1; GRANT ALL PRIVILEGES ON pokus1.* TO [EMAIL PROTECTED] IDENTIFIED BY 'heslo'; GRANT ALL PRIVILEGES ON pokus1.* TO pokus1@

Re: Access problem

2003-04-02 Thread Stefan Hinz
Arthur, trying to strip down your output to the very basics: mysql> select * from user; > | localhost | postfix | | Y mysql> select * from db; > | localhost | maildb | postfix | Y | N > # mysql -u postfix maildb > ERROR 1045: Access denied for user: > '[EMA

Access problem

2003-04-02 Thread Arthur Lessard
OK, I'm getting closer to a resolution of the problem I've had with mysql and postfix. I've got it narrowed down to an access problem on the database. As a relative novice to mysql, I thought I had things set right for the database access by the 'postfix' user account

Re: odd user/permissions/table access problem

2003-03-17 Thread Paul DuBois
At 12:10 -0800 3/17/03, Mike Whybark wrote: I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is

odd user/permissions/table access problem

2003-03-17 Thread Mike Whybark
I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is affected such that its' user access is disr

Access problem with users.

2002-09-23 Thread Julio Muñoz
Hello, We have 4000 db and 4000 user (more or less) in MySQL, each db has one user assigned. Some times, this is happened more often, show the next error: ERROR: 1045 'Access denied for user: ‘username@host’ (using password: YES). So we kill/restart the mysqld process … after th

Access problem with users.

2002-09-20 Thread Julio Cesar Munoz .
Hello, We have 4000 db and 4000 user (more or less) in MySQL, each db has one user assigned. Some times, this is happened more often, show the next error: ERROR: 1045 'Access denied for user: ‘username@host’ (using password: YES). So we kill/restart the mysqld process … after

DB Access problem

2001-11-18 Thread Kamaraj Shankar
Hi, I just installed MYSQL verion 3.23.44-max version. I verified the default database tables under tool WinMySQLAdmin and I could see all tables and fields of default databases. As per security advice, I removed the default user with command "DELETE FROM USER WHERE HOST="localhost" an