Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-16 Thread Érico
ok I have tried these : ifconfig -a lo0: flags=8049 mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff00 gif0: flags=8010 mtu 1280 stf0: flags=0<> mtu 1280 fw0: flags=8863 mtu 4078 lladdr 70:cd:60:ff:fe:eb:72:ea media:

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-15 Thread Claudio Nanni
Hi > > > | | ericomtxmacbookpro.local | > > *E85DC00A0137C6171923BE35EDD809573FB3AB4F | > > > > mysql> DELETE FROM mysql.user WHERE user=''; mysql> FLUSH PRIVILEGES; maybe helps? Cheers -- Claudio

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-14 Thread Érico
yes it is ... also , the eclipse is also local ... in both ... mysql-admin php application , plus inside eclispe plugin ... same behavior in both 2014/1/13 Reindl Harald > i doubt that the webserver is running on the same > machine as your mysql command shell > > Am 13.0

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
Am 13.01.2014 21:47, schrieb shawn l.green: > Hello Reindl, > We are not saying he is using HTTP commands to log into his database we excludes obviously the OP or his overall understanding :-) Am 13.01.2014 18:54, schrieb Érico: > using both urls I get the same error : > > http://localhost/mysql

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
Hello Reindl, On 1/13/2014 3:01 PM, Reindl Harald wrote: *your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
*your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that host* http://dev.mysql.com/doc/re

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
0.0.1... after I submit the index.php ... it redirects to localhost > too .. > > 2014/1/13 Reindl Harald > >> >> >> Am 13.01.2014 18:28, schrieb Érico: >>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin >>> Enter password: >&

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
Hi no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app my apache and pages are in the same computer that mysql I am not getting password issues.. otherwise I would not conne

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
Hello Érico, On 1/13/2014 1:49 PM, Érico wrote: Hi didn't work look ... isn't this something related to this : are you using "localhost" or "127.0.0.1" in the web-application root@localhost != root@127.0.0.1 = different users localhost: Unix-Socket 127.0.0.1: TCP ... since I am not able to

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
27; (using password: YES) > > > > > > > > > > 2014/1/13 Erick Ocrospoma > > > >> I forgot this. Do it too. > >> > >> On 13 January 2014 13:01, Erick Ocrospoma wrote: > >> > I presume your index.php file uses "127.

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
spoma wrote: >> > I presume your index.php file uses "127.0.0.1". After login to MySQL try >> this: >> > >> > $> grant all privileges to *.* 'root'@'127.0.0.1' identified by >> ; >> $> flush privileges; >> > &g

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
SQL try > this: > > > > $> grant all privileges to *.* 'root'@'127.0.0.1' identified by > ; > $> flush privileges; > > > > Of course this could not be the best solution, it's just to skip it, > > you must look at the query/connec

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
ileges; > > Of course this could not be the best solution, it's just to skip it, > you must look at the query/connection on your php file. > > On 13 January 2014 12:57, Érico wrote: >> using localhost the coonection works ... >> ericomtxmacbookpro:bin ericomtx$ ./mysql -u

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
ur php file. On 13 January 2014 12:57, Érico wrote: > using localhost the coonection works ... > ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost > -P 3306 > Enter password: > Reading table information for completion of table and column names > You ca

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
ro:bin ericomtx$ ./mysql -u root -p mysql-admin > > Enter password: > > Welcome to the MySQL monitor. Commands end with ; or \g. > > Your MySQL connection id is 31 > > Server version: 5.6.15 MySQL Community Server (GPL)> > > > > but in the browser I get the er

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
ned in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald wrote: > > > Am 13.01.2014 18:28, schrieb Érico: >> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin >> Enter password: >> Welcome to the MySQL monito

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
Am 13.01.2014 18:28, schrieb Érico: > ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 31 > Server version: 5.6.15 MySQL Community Server (GPL)> > >

Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
Hi I have installed mysql admin on my local environment I am able to connect to mysql through command line : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version

Re: PHP MYSQL Admin question

2009-07-23 Thread The Doctor
On Thu, Jul 23, 2009 at 08:47:41AM -0500, Johnny Withers wrote: > Are you sure MySQL is running? > Can you connect with any other MySQL client? > Turns out the php.ini was not set properly. > On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System > Administrator a.k.a. The Root of the P

Re: PHP MYSQL Admin question

2009-07-23 Thread Johnny Withers
Are you sure MySQL is running? Can you connect with any other MySQL client? On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: > Trying the latest phpMYAdmin on Mac OS X. > > Everything is set up correct but I get > > #2002 - The s

PHP MYSQL Admin question

2009-07-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling config.php where the mysql.sock file is located. Help. -- MySQL General Mailing List For l

How to create/change table to "federated" within MySQL Admin

2008-06-12 Thread Peter Prinzen
Hi, I want to change an existing table to StorageType "federated" according to http://dev.mysql.com/doc/refman/5.1/en/federated-create.html I've just created this sample table, now I can't even have a look at the scheme with mySQL Administrator, only the "mySQL Query Browser" works and shows me th

RE: MySQL admin GUI

2007-07-16 Thread Jerry Schwartz
; From: Jim Ginn [mailto:[EMAIL PROTECTED] > Sent: Friday, July 13, 2007 3:16 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: MySQL admin GUI > > Jerry: > > or: > > http://www.phpmyadmin.net/home_page/index.php > > ? > > Thanks! > >

Re: MySQL admin GUI

2007-07-13 Thread Manolov, Mihail
Sent: Fri Jul 13 15:26:00 2007 Subject: Re: MySQL admin GUI The only way I know how to do this with MySQL Admin is to alter the sql code it shows you after clicking apply (add and "after column_name") before executing On 7/13/07 3:05 PM, "Jerry Schwartz" <[EMAIL PROTECT

Re: MySQL admin GUI

2007-07-13 Thread Olaf Stein
The only way I know how to do this with MySQL Admin is to alter the sql code it shows you after clicking apply (add and "after column_name") before executing On 7/13/07 3:05 PM, "Jerry Schwartz" <[EMAIL PROTECTED]> wrote: > Does anyone know how to add a field

Re: MySQL admin GUI

2007-07-13 Thread Jim Ginn
Jerry: or: http://www.phpmyadmin.net/home_page/index.php ? Thanks! Jim Ginn http://www.Tenant.com > Does anyone know how to add a field anyplace but at the bottom? I haven't > found any "insert here" functionality. > > Regards, > > Jerry Schwartz > The Infoshop by Global Information Incorpora

MySQL admin GUI

2007-07-13 Thread Jerry Schwartz
Does anyone know how to add a field anyplace but at the bottom? I haven't found any "insert here" functionality. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com

Re: Searching for a MySQL Admin at TiVo

2006-09-20 Thread Joao Candido de Souza Neto
This person ought to be in USA? ""Leann Das"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > If anyone would be interested in a contract, please contact me! > > Thanks! > > > Leann Das > Recruiter, TiVo > http://www.tivo.com/

Searching for a MySQL Admin at TiVo

2006-09-20 Thread Leann Das
If anyone would be interested in a contract, please contact me! Thanks! Leann Das Recruiter, TiVo http://www.tivo.com/ [EMAIL PROTECTED] Phone: 408-519-9134 Get the inside track to great jobs at TiVo

Experienced MySQL Admin Needed

2006-01-11 Thread Rick Dwyer
I am looking for an experience MySQL administrator in the Connecticut area to help us with our MySQL configuration. ideally, we need someone experienced with configuring automated backups, server optimization, query optimization, replication and troubleshooting. We operate OS X (10.3.9)/ MySQ

Re: automatic backups not working MySql Admin

2005-10-12 Thread Rich
If you open your terminal, you'll see some error messages waiting for you. Apparently it's buggy. I turned off my admin backups. Cheers John Doneker: > Is this because this free software doesn't supply this functionality? Or could > it be a bug? Is there another answer? -- MySQL General Ma

automatic backups not working MySql Admin

2005-10-12 Thread John Doneker
I've downloaded the MySQL Admin 1.1 freeware tool to backup a mysql database. It works fine except that the timer doesn't work. When I set a time in the 'time' field, lets say 8:00, the backup never kicks off. Is this because this free software doesn't supply this fu

MySQL Admin Keeps crashing on FC3

2004-12-06 Thread Victor Medina
Hi all! I recently updated my system to FC3, i installed MySQL Administrator from the mysql.com binaries, but they keep crashing every time. This is the error message: [EMAIL PROTECTED] ~]$ /opt/mysql-administrator/bin/mysql- administrator *** glibc detected *** free(): invalid pointer: 0x0852256

Re: mysql admin clients

2004-11-05 Thread Karam Chand
Hello, Check out SQLyog at http://www.webyog.com/forums/index.php?s=94f4afb247fdfdfbd6435d793a56d60a&act=ST&f=2&t=977&st=0&#entry3909 Its FREE and very powerful. Regards, Karam --- leegold <[EMAIL PROTECTED]> wrote: > newbie question about mysql admin clients. W

Re: mysql admin clients

2004-11-02 Thread Andy Davidson
On 1 Nov 2004, at 22:57, leegold wrote: newbie question about mysql admin clients. What are some good ones? And importantly can they access and allow me to edit the db record fields themselves? eg. I see a mis-spelled word in a field - I could go in there and edit the field. I use one called

Re: mysql admin clients

2004-11-02 Thread Martijn Tonies
> newbie question about mysql admin clients. What are some good ones? And > importantly can they access and allow me to edit the db record fields > themselves? eg. I see a mis-spelled word in a field - I could go in > there and edit the field. Have a look at Database Workbench: www

Re: mysql admin clients

2004-11-02 Thread Gleb Paharenko
Hi. See: http://www.mysql.com/products/mysqlcc/ "leegold" <[EMAIL PROTECTED]> wrote: > newbie question about mysql admin clients. What are some good ones? And > importantly can they access and allow me to edit the db record fields > themselves? eg. I see a mis-sp

Re: mysql admin clients - But can I edit a column field?

2004-11-01 Thread ian douglas
But can I edit a column field? Can I go into a specific column in a specific record and edit it just like I was in a text editor? That's the action I want. None on the products specifically state they can do it(?) phpMyAdmin will allow you to alter a column name within a table, yes. can't speak for

Re: mysql admin clients - But can I edit a column field?

2004-11-01 Thread leegold
can I edit a column field? Can I go into a specific column in a specific record and edit it just like I was in a text editor? That's the action I want. None on the products specifically state they can do it(?) Thanks > > l> newbie question about mysql admin clients. What are so

mysql admin clients

2004-11-01 Thread leegold
newbie question about mysql admin clients. What are some good ones? And importantly can they access and allow me to edit the db record fields themselves? eg. I see a mis-spelled word in a field - I could go in there and edit the field. Thanks, lee G> -- MySQL General Mailing List For l

MySQL admin

2003-03-08 Thread FlashGuy
When I go into the "Database" tab of my SQL Admin I don't see any databases? Should I not see the ones that are in the datadir path? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba ---

Re: MySQL admin with no password

2002-01-12 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > > We used to do that, but got complaints: > https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=51711 > > It wreaked havoc on bin-logs. > > OTOH, we need to be able to have scripts controlling the DB as root, > while not needing to have a passwordless DB accoun

Re: MySQL admin with no password

2002-01-11 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > Is there a clean way to administrate mysqld without a password by > > root? > > > > I'm looking for ways to make it flush logs, reload my.cnf and shut > > down cleanly, in an automated way - i.e, no password, but

Re: MySQL admin with no password

2002-01-11 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > Is there a clean way to administrate mysqld without a password by > root? > > I'm looking for ways to make it flush logs, reload my.cnf and shut > down cleanly, in an automated way - i.e, no password, but by root. > > (similar to pg_ctl for postgresql or `kill -H

MySQL admin with no password

2002-01-10 Thread Trond Eivind Glomsrød
Is there a clean way to administrate mysqld without a password by root? I'm looking for ways to make it flush logs, reload my.cnf and shut down cleanly, in an automated way - i.e, no password, but by root. (similar to pg_ctl for postgresql or `kill -HUP` for reloading) (e.g. shut down the serv

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Re: sysdate() query and note to Mysql admin

2001-09-07 Thread Ed Carp
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: > now,what statement do I use to put the sysdate into the column today? > this is NOT working > insert into datee values(select DAYOFMONTH(sysdate())); Of course not. "insert into datee values (Now())" will, though. Just feed it to mysql ... ;) Here

ODP: sysdate() query and note to Mysql admin

2001-09-07 Thread Daniel Łaś
TED] > Temat: sysdate() query and note to Mysql admin > > > > Hi, > I my name is ryan and I own a small site which has a mysql > database and servlet support. > > I have a simple query to all you mysql gurus... > my table is very simple, i created a table with the foll

sysdate() query and note to Mysql admin

2001-09-07 Thread ryan
Hi, I my name is ryan and I own a small site which has a mysql database and servlet support. I have a simple query to all you mysql gurus... my table is very simple, i created a table with the following create table datee(int today); now,what statement do I use to put the sysdate into the colu