Re: mysql Access denied error

Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, EdwardKing wrote: > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > fa

Re: mysql Access denied error

On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql> create data

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> i know that, but it does not change the fact that here > > Either you didn't know that but have trouble admitting it; or you did but > conciously chose to be rude and condescending in

Re: mysql Access denied error

- Original Message - > From: "Reindl Harald" > > i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I

Re: mysql Access denied error

Am 05.05.2014 11:12, schrieb Jigal van Hemert: > On 5-5-2014 10:57, Reindl Harald wrote: >> >> >> Am 05.05.2014 10:19, schrieb Manuel Arostegui: >>> 2014-05-05 10:00 GMT+02:00 Reindl Harald >> >: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> >

Re: mysql Access denied error

Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald mailto:h.rei...@thelounge.net>>: Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be

Re: mysql Access denied error

2014-05-05 10:57 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 10:19, schrieb Manuel Arostegui: > > 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net>>: > > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > > "%" doesn't match localhost so if you don't specify it you wi

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: > 2014-05-05 10:00 GMT+02:00 Reindl Harald >: > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix So

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix Socket. > > If you don't want to specify -hlocalhost all the time, just do the grant > > with "@

Re: mysql Access denied error

Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be > attempting to connect via Unix Socket. > If you don't want to specify -hlocalhost all the time, just do the grant > with "@localhost" instead of "@%" nonsense % matches *any hos

Re: mysql Access denied error

2014-05-05 4:17 GMT+02:00 EdwardKing : > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > failed. Why raise error after I grant rights? How to solve it? Thanks. > > My operation is follows: > > [hadoop@maste

mysql Access denied error

I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password

Re: REstricting MySQL access to port 3306

by firewall . > > > > > > Willy > > Sent from my Sony Ericsson XPERIA™ X1. > > > > -Original Message- > > From: John > > Sent: 24 September 2009 15:07 > > To: 'The Doctor' ; mysql@lists.mysql.com > > Subject: RE: REstricting

Re: REstricting MySQL access to port 3306

> > Willy > Sent from my Sony Ericsson XPERIA™ X1. > > -Original Message- > From: John > Sent: 24 September 2009 15:07 > To: 'The Doctor' ; mysql@lists.mysql.com > Subject: RE: REstricting MySQL access to port 3306 > > I don't think there

RE: REstricting MySQL access to port 3306

Limit connection from trusted host will reduce it. And its better handled by firewall . Willy Sent from my Sony Ericsson XPERIA™ X1. -Original Message- From: John Sent: 24 September 2009 15:07 To: 'The Doctor' ; mysql@lists.mysql.com Subject: RE: REstricting MySQL access to

Re: REstricting MySQL access to port 3306

(CMDBA) > Certified MySQL 5 Developer (CMDEV) > IBM Cognos BI Developer > > Telephone +44 (0)7812 451238 > Email j...@butterflysystems.co.uk > > -Original Message- > From: The Doctor [mailto:doc...@doctor.nl2k.ab.ca] > Sent: 24 September 2009 07:38 > To: mysql@

RE: REstricting MySQL access to port 3306

@lists.mysql.com Subject: REstricting MySQL access to port 3306 Some months a back I had to firewall port 3306 due to DDoS. I cannot do this now as a client needs 3306 outside the LAN. What can I do to prevent DDoS on my MySQL server? -- Member - Liberal International This is doc...@nl2k.ab.ca I

REstricting MySQL access to port 3306

Some months a back I had to firewall port 3306 due to DDoS. I cannot do this now as a client needs 3306 outside the LAN. What can I do to prevent DDoS on my MySQL server? -- Member - Liberal International This is doc...@nl2k.ab.ca Ici doc...@nl2k.ab.ca God, Queen and country! Beware Anti-Chris

Re: neet setup tips for remote mysql access

Hello. >ERROR 2003 (HY000): Can't connect to MySQL server on 'myDomain.com' (10061) See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html "YL" <[EMAIL PROTECTED]> wrote: >I have mysql server and php apps on the same machine, they worked very well. >The machine's

Re: neet setup tips for remote mysql access

Could it be the firewall? You might want to open the port 3306 for external access(or both). In my XP, I did this: Firewall --> Advance--> Network Connection Settings -->Select Local Area Connection --> Click Setting, then you might want to 'add...', from there filling your IP, 3306 for both ports

neet setup tips for remote mysql access

Dear List, I have mysql server and php apps on the same machine, they worked very well. The machine's OS is win2k pro Mysql 5.0.15 Then I access the db from local network area 192.l68 And it worked fine although I have to reset my account privileges.. Then I tried to access it remotely by d

RE: Intersting MySQL / Access Issue

31 PM To: mysql@lists.mysql.com Subject: Intersting MySQL / Access Issue Dear Community, My team and I have been experiencing an interesting mysql error during the past few weeks of testing. Here is the scenario we are trying to accomplish. We are essentially working to use MsAccess as a wi

Re: Intersting MySQL / Access Issue

Raj Goel wrote: >Dan, > > Here's what I've narrowed it down to: > > We're updating FROM Access TO MySql. > > If the column in Access is blank/empty, then the error pops up. > > If the field has data, then the error does not pop up. > > So, somewhere, either Access, or

Re: Intersting MySQL / Access Issue

Edward Maas wrote: >"You Tried to assign the Null value to a variable that is not a > Variant data type." > From my searching, I was unable to find how to set fields to variant > data types. Secondly, I am not sure which field is causing the error. No kidding. Looking into my crystal ball, I

Intersting MySQL / Access Issue

Dear Community, My team and I have been experiencing an interesting mysql error during the past few weeks of testing. Here is the scenario we are trying to accomplish. We are essentially working to use MsAccess as a windows client for a linux based mysql databases. We have installed myO

Re: Help restoring mysql access

Thursday, April 22, 2004, 9:21:35 PM, Dave Dennis wrote: DD> Is there a procedure to follow for this exactly, step by step? Yes. DD> Its on a running production server, don't want to lose data. Note: If you run MySQL server with --skip-grant-tables option, MySQL will not use privilege tables.

Re: Help restoring mysql access

Dave Dennis <[EMAIL PROTECTED]> wrote: > Dear MySQL list, > > Managed to create a problem where: > > mysql > use mysql; > > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' > > Need a procedure to follow / documented steps to restore root's access > to database mysql,

Help restoring mysql access

Dear MySQL list, Managed to create a problem where: mysql > use mysql; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' Need a procedure to follow / documented steps to restore root's access to database mysql, version 4.0.17 . Kind regards, +

Re: MySQL access issue

this link from the mysql docs should help http://www.mysql.com/doc/en/Resetting_permissions.html - hcir Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for th

MySQL access issue

Hello everyone, Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for the db's and frankly I'm not an MySQL buff to be honest. Our DB Admin is gone now, I ne

Mysql access through ODBC

Hi, I have a Mysql table which has over 4 records. If i want to access from VB using ODBC connection. will that be good choice related to performance wise. or any other options there. Thanks in advance. Regards priya __ Do you Yahoo!? SBC Yahoo! DSL - Now

Re: mysql access error 1044 - update

If you want to set the root password you can do the next thing 1. kill the mysqld 2. start mysqld with --skip-grant-tables option 3. set the new password with mysqladmin -u root password 'RogerTheRabbit' command 4. and finally - mysqladmin -h hostname flush-privileges instead of 3 and 4 you

mysql access error 1044 - update

Hi all - thanks so much for the advice that has been coming in regarding my mysql local installation problems. Here's what's going on - Tim and Paul - I especially appreciated your replies - do you have any ideas on the following: I reinstalled mysql (made sure I downloaded the binary with the i

RE: MySQL access denied

this as it says is an incorrect username or password Andrew >-Original Message- >From: Jon L. Miller [mailto:[EMAIL PROTECTED] >Sent: 06 April 2003 10:42 >To: [EMAIL PROTECTED] >Subject: MySQL access denied > > >I'm having a problem accessing MySQL via phpM

MySQL access denied

I'm having a problem accessing MySQL via phpMyAdmin. I've inserted in the 1st line of the config.inc.php3 $cfgPmaAbsoluteuri="; I can access MySQL via CLI and I have set the username and password via mysqladmin for the major users. But I'm still getting the following when trying to access the data

re: mysql: access denied for what?

Jack, Tuesday, November 05, 2002, 4:20:58 AM, you wrote: JC> After I made mysqld running, I then tried: JC> >mysql -u root JC> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) JC> What does this mean? It means that user 'root'@'localhost' without a password doesn't have

mysql: access denied for what?

Dear all, After I made mysqld running, I then tried: >mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What does this mean? Thanks Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Sp

Mysql --> Access

Is there a way to take a mysql database and import it into access retaining all the rules and relationships setup within the mysql databse? --- Aaron Axelsen AIM: AAAK2 Email: [EMAIL PROTECTED] URL: www.amadmax.com "It said, ""Insert disk #3,"" but only two will fit!" "One picture is worth 128K

RE: mysql access via php function, hlp with syntax

--- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Randy Hammons [mailto:rathlon1@;cox.net] Sent: 26 October 2002 18:45 To: mysql Subject: mysql access via php function, hlp with syntax Can someone please tell me what is wrong

mysql access via php function, hlp with syntax

Can someone please tell me what is wrong with this function? I can't for the life of me see an error. But, for some reason I keep getting the following error: PARSE ERROR: parse error, unexpected $ in "d:\web.root\xx_db\inc\functions1.inc on line 28 function is: function dtb_qry_tbl_dsp($qry,

Re: MySql <- Access

fields. It transparently change the datatype to mysql column types. - Original Message - From: "Donna Robinson" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 05, 2002 5:27 AM Subject: Re: MySql <- Acc

Re: Delphi MySQL Access Components

l Kiss" <[EMAIL PROTECTED]> > CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: Delphi MySQL Access Components > Sent: Thu, 25 Jul 2002 00:39:12 GMT > Received: Thu, 25 Jul 2002 03:02:11 GMT > Read: Sat, 30 Dec 1899 00:00:00 GMT > Daniel, > P

Re: Delphi MySQL Access Components

gt; Cc: <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 5:39 PM Subject: Re: Delphi MySQL Access Components > Daniel, > Personally I found ZEOS a pain in proverbial - poorly documented, > constant AVs etc.. D6 dbExpress works very well for me, but I think it > only comes with D6 Enterp

Re: Delphi MySQL Access Components

Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL

RE: Delphi MySQL Access Components

4:23 PM > To: [EMAIL PROTECTED] > Subject:Delphi MySQL Access Components > > Hi, > > Can someone tell me what is the best MySQL native component set for >Delphi? > It does not matter if i

Re: Delphi MySQL Access Components

Daniel, Wednesday, July 24, 2002, 11:23:05 AM, you wrote: DK> Can someone tell me what is the best MySQL native component set for Delphi? DK> It does not matter if it is commercial, but I need one urgently. I'm not a professional with Delphi+MySQL, but Zeos Library looks fine for me: http://

Delphi MySQL Access Components

Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/ma

Re: Query realted to Mysql access.

OOPS! Bob Bell wrote: >On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark ><[EMAIL PROTECTED]> wrote: > >>Naathan wrote: >> >>>I am getting the following error message like . >>> >>>" [TCX][MyODBC]Host is not allowed to connect this MySQL >>>server " >>> >>>Kindly let me know how to connec

Re: Query realted to Mysql access.

On Thu, Jul 11, 2002 at 08:32:28AM -0500, Gerald Clark <[EMAIL PROTECTED]> wrote: > Naathan wrote: > >I am getting the following error message like . > > > >" [TCX][MyODBC]Host is not allowed to connect this MySQL > >server " > > > >Kindly let me know how to connect the MySQL database stored on

Re: Query realted to Mysql access.

Naathan wrote: >Hello, > >Greetings! > >I am trying hard to connect to MySQL database stored on Linux machine >through a >VB program running on windows on another machine. > >My problems are .. > >Problem No1: > >My Windows machine is under a Windows NT domain. >Linux machine is under another W

Re: Query realted to Mysql access.

No1. Sounds like a permission problem. Make sure that you have that domain in the list of computer allowed to connect to MySQL. Refer to MySQL manual to get more information about this. No2. PC based application won't run on Linux unless you run them under an PC-emulator which I don't even know i

Query realted to Mysql access.

Hello, Greetings! I am trying hard to connect to MySQL database stored on Linux machine through a VB program running on windows on another machine. My problems are .. Problem No1: My Windows machine is under a Windows NT domain. Linux machine is under another Windows NT domain. I created a d

RE: MySQL access denied problem

Hello, > -Original Message- > From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 04, 2002 12:44 PM > To: Simas Cepaitis > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL access denied problem > > > What was the error message appear

Re: MySQL access denied problem

Pada Thu, 4 Jul 2002 10:40:36 +0200 Simas Cepaitis <[EMAIL PROTECTED]> menulis : > Hello, > > > I have a problem that happens periodically on my FreeBSD 4.6 box. > Somehow MySQL (3.23.49) stops responding after some period. It > doesn't allow to connect any user except root ( and it's not

MySQL access denied problem

Hello, I have a problem that happens periodically on my FreeBSD 4.6 box. Somehow MySQL (3.23.49) stops responding after some period. It doesn't allow to connect any user except root ( and it's not because max_connections, there aren't active connections at the time). The only thing that h

RE: External MySQL access from Windows

ailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: re: External MySQL access from Windows Its not clear from the docs if external mySQL databases (say running on a linux system) can be linked to Windows database with myODBC. Does this work bi-directio

re: External MySQL access from Windows

Its not clear from the docs if external mySQL databases (say running on a linux system) can be linked to Windows database with myODBC. Does this work bi-directionally (ie can I retrieve info from the linux databases and update records on the linux box with queries from windows? Thanks, DB -

Re: remote mysql access ?????

toby, Friday, June 21, 2002, 12:05:26 PM, you wrote: t> ok guyz somebody was talkin about accessing mysql from a remote machine t> how the devil do i do that ? You can connect using mysql command-line client or any GUI for MySQL, f.e. MyCC: http://www.mysql.com/downloads/gui-mycc.html t>

RE: remote mysql access ?????

ted to have, mysql will work without it and you can create it yourself if you need to add parameters to it Hope it helps, CB. -Original Message- From: toby - [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:05 To: [EMAIL PROTECTED] Subject: remote mysql access ? ok g

remote mysql access ?????

ok guyz somebody was talkin about accessing mysql from a remote machine how the devil do i do that ? the problem is : 1.i have mysql on my work machine ... not at my home & i dont wanna have to go thru all the trouble of download and config and all 2. i couldnt locate my.ini or my.cnf wha

[JDBC / MySQL] Access Denied for User ?

I am not sure if a Java JDBC error is appropriate for this list or not. If not, I apologize in advance. I'm getting the error below that I'm trying figure out where to start researching... "Invalid authorization- access denied for user"... This seems strange b/c I'm using "root" as username, "s

RE: MySQL & Access 97 slow

> -Original Message- > From: Tom Worobec [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 04, 2002 12:56 AM > To: MySQl Lists > Subject: MySQL & Access 97 slow > > > Why do linked MySQl tables in Access 97 take longer to open > thne linked > Acce

RE: MySQL & Access 97 slow

It's ODBC in general. One more layer of abstraction to deal with. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Tom Worobec [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:56 AM To: MySQl Lists Subject:

MySQL & Access 97 slow

Why do linked MySQl tables in Access 97 take longer to open thne linked Access 97 tables in Access 97? Is it MyODBC? Tom Worobec --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 5/24/2002

Script fails during MySQL access attempt.

Dear MySQL wizards, Perhaps this is more of a Perl question than a mySQL question but I am trying to access a mySQL database. Here is the line of code. if ($q->param('field') eq "") {&printform()} else {&results()} This gives the reply: Use of unitialized value in string eq at select.cgi

RE: [MySQL] Access denied on LOAD DATA INFILE statement - no subject provided with posting

Amit, Perhaps try running your LOAD DATA INFILE statement typed at the command prompt of the mysql client, and maybe you will get more info as to what the problem is. You may have a MySQL installation where the 'LOAD DATA INFILE' statement is not permitted by default. However, the

Bug ? : Mysql access rights problem ...

Bonjour, I have a problem with Mysql and access rights : I have a user who has rights to access tables in the database 'membres' : #/> mysqlaccess 192.168.0.1 myuser membres Could not open outputfile ~/mysqlaccess

Mysql access rights problem ...

Bonjour, I have a problem with Mysql and access rights : I have a user who has rights to access tables in the database 'membres' : #/> mysqlaccess 192.168.0.1 myuser membres Could not open outputfile ~/mysqlaccess

RE: MySQL + Access + MyODBC + LARGE Tables

Hi, > -Original Message- > From: Bill Adams [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:04 PM > To: MyODBC Mailing List; MySQL List > Subject: RE: MySQL + Access + MyODBC + LARGE Tables > > > All, there were many emails posted about this

RE: MySQL + Access + MyODBC + LARGE Tables

All, there were many emails posted about this on the MyODBC list which, of course, can be viewed via the archive on the mysql.com site. For the most part I will neither quote nor repeat the information from those emails here. The conclusion is that MySQL + Merge Tables is perfectly capable of b

RV: MySQL + Access + MyODBC + LARGE Tables

-Mensaje original- De: Eugenio Ricart [mailto:[EMAIL PROTECTED]] Enviado el: viernes, 15 de febrero de 2002 7:00 Para: MyODBC Mailing List Asunto: RE: MySQL + Access + MyODBC + LARGE Tables Hello, I work with VB 6.0 ADO 2.5 Access , I am trying work with MySql & and the Last My

RE: MySQL + Access + MyODBC + LARGE Tables

enter: SQLFreeStmt: 15c780 option: 0 SQLFreeHandle | info: SQLFreeHandle: 15c780 | >SQLFreeStmt | | enter: SQLFreeStmt: 15c780 option: 1 | SQLFreeHandle | info: SQLFreeHandle: 15bd68 | >SQLFreeStmt | | enter: SQLFreeStmt: 15bd68 option: 1 | > The bottom line is that in order for MySQL + Acce

Re: MySQL + Access + MyODBC + LARGE Tables

es the load on all programs involved. The astute >reader will realize that if one uses mysql_use_result and does not fetch >all of the records, the next query will return the remaining records >from the previous query first. It follows that Access bombs because in >statement #2 it is g

RE: MySQL + Access + MyODBC + LARGE Tables

ll return the remaining records > from the previous query first. It follows that Access bombs because in > statement #2 it is getting results from statement #1. (This is seen from > the myodbc.log line: " | error: message: Commands out of sync; You > can't run this command

RE: MySQL + Access + MyODBC + LARGE Tables

know you probably are aware of this issue but it didn't hurt to say it (*_*). I hope this helped at least a little. -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 6:05 PM To: MySQL List; MyODBC Mailing List Subject: MySQL + Access + MyO

MySQL + Access + MyODBC + LARGE Tables

ine: " | error: message: Commands out of sync; You can't run this command now" in the myodbc3.dll changed to use the said function.) The bottom line is that in order for MySQL + Access + MyODBC to be usable as a datawarehouse MySQL/MyODBC (a) must be able to return uncached results; a

mysql access control

Joachim, Monday, January 28, 2002, 2:15:51 PM, you wrote: JH> I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4) JH> After the installation of mysql I run the mysql_install_db script JH> I could change the passwords for root so I reset the GRANT table using JH> ../safe_my

Re: mysql access control

At 13:15 +0100 1/28/02, Joachim Hörnle wrote: >The mysql access control is drinving me crazy. > >I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4) >After the installation of mysql I run the mysql_install_db script > >I could change the passwords for r

mysql access control

The mysql access control is drinving me crazy. I have installed MySQL Version 3.23.47 on Suse Linux 7.2 (Kernel 2.4.4) After the installation of mysql I run the mysql_install_db script I could change the passwords for root so I reset the GRANT table using ../safe_mysqld --skip-grant-tables

MyODBC, MySQL & Access 2000

I downloaded and installed the latest MyODBC drivers for Win2000 and got everything installed and configured. My question is this, when I run an append query, Access pops-up a message box saying something like: You are about to append 737 records, are you sure you wish to continue? Regardless

Re: MySQL access denied from localhost

Hi, - Original Message - From: "mweb" <[EMAIL PROTECTED]> > I know this is a probably a FAQ, and have read > http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to > me. If I look at the mysql db from the monitor I get all the privileges OK > for user "testuser" Lo

MySQL access denied from localhost

I know this is a probably a FAQ, and have read http://www.mysql.com/doc/A/c/Access_denied.html, but everything looks OK to me. If I look at the mysql db from the monitor I get all the privileges OK for user "testuser" (see below, and still (from PHP UnixOdbc on Apache) get thist message when I

Re: Re[4]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | > >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' > | > >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO

Re: Re[6]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | > >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' > | > >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON cont

Re[6]: Bug in Mysql access rights ?

Sinisa, >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD >'' | >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' >| >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' >

Re[4]: Bug in Mysql access rights ?

Sinisa, >> mysql> show grants for news@'192.168.1.%'; >> >++ >> | Grants for [EMAIL PROTECTED]% > | >> >+---

Re: Re[2]: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Sinisa, > > mysql> show grants for news@'192.168.1.%'; > >++ > | Grants for [EMAIL PROTECTED]% >| > >+

Re[2]: Bug in Mysql access rights ?

Sinisa, >> What's happening ? SM> Your story is quite strange. SM> Can you run SHOW GRANTS on both user@localhost and user@remoteIP and SM> see what they are showing ?? I had to make my applications work, so I removed the lines in 'user' and 'db' tables for the remote IP. This solved

Re: Bug in Mysql access rights ?

BAUMEISTER Alexandre writes: > Bonjour, > > What's happening ? > > Regards, > Alex. Your story is quite strange. Can you run SHOW GRANTS on both user@localhost and user@remoteIP and see what they are showing ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr

Bug in Mysql access rights ?

Bonjour, I have a problem with Mysql-3.23.39 and users access rights. It's the second time I notice this problem since I installed .39 on two of my servers. But yesterday, the bug was even more flagrant. I had a user which had all rights on a database when connecting from localhos

MySQL Access

Hello I have Linux Red Hat 7 server with MySQL database server I would like to connect a win 2000 computer via IP throught MyODBC When I try to connect ODBC driver return host " unable to connect this MySQL server" I have create an user with host with all access on mysql database What's

mysql access problems

Why do I get message "Can't connect Mysql server throuht mysql.sock "?

MySQl // Access // ODBC

Hi, i read the manual. but i don't know what to do. I have a table. only 2 columns without a primary key. so i made the following: alter table 'tablename' add id auto_increment primary key; and alter table 'tablename' add Misc timestamp; But all fields are filled with #deleted. i don't hav

mysql access

Dear sir, I installed mysql on my apache server. However when I want to access the mysql database through my perl scripts. Following error occurs while running the scripts : install_driver (failed) : perhaps a module that DBD::mysql requires has not been fully installed. Could you please