Re: password problem

2015-07-31 Thread Martin Mueller
mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing

Re: password problem

2015-07-31 Thread Reindl Harald
Am 31.07.2015 um 14:40 schrieb Martin Mueller: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix

Re: password problem

2015-07-31 Thread Reindl Harald
stuff, but you're short on patience, and it would help you a lot to practice a little courtesy and refrain from vulgar language. well, i am developer and sysadmin, not a politican my first response pointed again to the docs and quotet that: Resetting the Root Password: Generic Instructions Stop

Re: password problem

2015-07-31 Thread Reindl Harald
that it contains, if they do not exist. On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password

Re: password problem

2015-07-31 Thread Reindl Harald
system the user mysql has a password, hence no login possible and typically it has also no shell configured b) for what reason mysql -u root and you are done with skip-grant-tables (and skip-grant-tables is the only relevant point) why in the world should i need to logon as the user

Re: password problem

2015-07-31 Thread Martin Mueller
Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix user that the MySQL server runs as (for example

Re: password problem

2015-07-31 Thread Martin Mueller
user account 'mysql'. It can be changed if you want to change it but that is the default. That is why 'mysql' was listed in the for example section of that instruction but this part of the docs is completly bullshit a) on no sane system the user mysql has a password, hence no login possible

Re: password problem

2015-07-31 Thread shawn l.green
On 7/31/2015 8:40 AM, Martin Mueller wrote: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix

Re: password problem

2015-07-31 Thread Reindl Harald
I have no password for ANY thing. read the f**ng https://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html - unbelievebale that users these days need anything ready chewed and are too lazy to click on a link and read more than 5 lines Resetting the Root Password: Generic

Re: password problem

2015-07-31 Thread nikhil anand
Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know nothing or there is some error in the installation process

Re: password problem

2015-07-30 Thread Reindl Harald
Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation

password problem

2015-07-30 Thread Martin Mueller
I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation has somehow installed passwords about which I know

Re: how can i login without a password although in the user-table is a password ?

2015-06-30 Thread Lentes, Bernd
Bernd wrote: a password ? Hi, this is my system: mysql status -- mysql Ver 14.12 Distrib 5.0.26, for suse-linux (x86_64) using readline 5.1 Connection id: 142883 Current database: mysql Current user: root@localhost SSL

how can i login without a password although in the user-table is a password ?

2015-06-30 Thread Lentes, Bernd
:/var/lib/mysql/mysql.sock Uptime: 223 days 22 hours 38 min 49 sec Threads: 1 Questions: 9178423 Slow queries: 99 Opens: 607644 Flush tables: 3 Open tables: 64 Queries per second avg: 0.474 my user-table looks like this: mysql select host,user,password from user

access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Érico
I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Reindl Harald
Am 29.05.2014 20:22, schrieb Érico: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Kishore Vaishnav
=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect through command line again ? thks

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Érico
a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') how can I restore the db so I can connect

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Érico
=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root'@'localhost (using password:'NO') your command line is plain wrong as you can see in the response you are *not* using a password

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Reindl Harald
well, i am mysql administrator over 10 years now and never needed the mysqladmin command because the mysql command line client offers anything i ever needed mysql -u root -p [harry@srv-rhsoft:~]$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread shawn l.green
Hello Érico On 5/29/2014 2:22 PM, Érico wrote: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user 'root

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread Érico
am mysql administrator over 10 years now and never needed the mysqladmin command because the mysql command line client offers anything i ever needed mysql -u root -p [harry@srv-rhsoft:~]$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your

Re: access denied fpr user 'root'@'localhost' (using password: NO)

2014-05-29 Thread shawn l.green
is the result of this query: SELECT user, host, length(password) from mysql.user; What hapens if you change your login to this? (you should not put your passwords on your command lines if you can avoid it http://dev.mysql.com/doc/refman/5.6/en/password-security-user.html http://dev.mysql.com/doc/refman

[5.1 Vs 5.5 ] ERROR 1045 (28000): Access denied for user 'testuser'@'Serv1.corp.domain.in' (using password: YES)

2014-04-03 Thread Vinay Gupta
Hi, I am trying to connect two mysql servers with different versions ( 5.1 5.5 ) . But in Mysql 5.1 i am facing strange issues. Below testuser exists in both Mysql Versions : mysql select host,user,password from mysql.user where user='testuser

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=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384 inet6 ::1 prefixlen 128 inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1 inet 127.0.0.1 netmask 0xff00 gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280 stf0: flags=0 mtu 1280 fw0:

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
13.01.2014 23:59, schrieb Érico: true but please check this out : mysql Select user, host, password from mysql.user; +--+--+---+ | user | host | password

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: 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) but in the browser I get

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

2014-01-13 Thread Erick Ocrospoma
in your web app as you've been told in the mail before. On 13 January 2014 12:36, Reindl Harald h.rei...@thelounge.net wrote: 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

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

2014-01-13 Thread É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) but in the browser I get the error : Access denied for user 'root'@'localhost

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 Erick Ocrospoma
2014 12:57, Érico erico...@gmail.com 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 can turn off this feature to get

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

2014-01-13 Thread Erick Ocrospoma
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 monitor. Commands end with ; or \g. Your MySQL connection id is 97 Server version: 5.6.15 MySQL Community Server (GPL

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

2014-01-13 Thread Érico
the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237

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

2014-01-13 Thread Erick Ocrospoma
password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) Could not connect to New MySQL. Error creating SQL Model Connection

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

2014-01-13 Thread Érico
error :) It should be: mysql grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'kernel26'; ... in eclipse using jconnector ... I get the same error : when pinging : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES

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

2014-01-13 Thread shawn l.green
' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will not authenticate. You also need to remember that if your .php page

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

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

2014-01-13 Thread Reindl Harald
the index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald h.rei...@thelounge.net 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

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

2014-01-13 Thread Reindl Harald
computer that mysql I am not getting password issues.. otherwise I would not connect through command line 2014/1/13 shawn l.green shawn.l.gr...@oracle.com 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

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

2014-01-13 Thread shawn l.green
failing to connect? We are not saying he is using HTTP commands to log into his database. We have clarified that both his client and his server are on the same host. My last advice is that the password he is providing through his other clients must be incorrect. I even suggested that he may

RE: Access denied for user 'root'@'localhost' (using password:

2014-01-13 Thread Vikas Shukla
provide the output of the below query. Select user, host, password from mysql.user; Thanks Vikas Shukla Mail Sent from my Windows Phone From: Reindl Harald Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38 To: mysql@lists.mysql.com Subject: Re: Access denied for user 'root'@'localhost' (using

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 :

Re: Transfer ENCRYPT password field to another server

2013-07-20 Thread Rik Wasmus
From: Johan De Meersman vegiv...@tuxera.be To:J Gao j...@veecall.com @ 2013-07-19 From: J Gao j...@veecall.com Subject: Transfer ENCRYPT password field to another server So, is there a way to make the MySQL encrypted password string 2I6JOeg.JukJ. convert to MD5 hash $1

Re: Transfer ENCRYPT password field to another server

2013-07-19 Thread Johan De Meersman
- Original Message - From: J Gao j...@veecall.com Subject: Transfer ENCRYPT password field to another server So, is there a way to make the MySQL encrypted password string 2I6JOeg.JukJ. convert to MD5 hash $1$.? Nope. Encrypt() calls unix crypt(), which is really

Transfer ENCRYPT password field to another server

2013-07-18 Thread J Gao
Hi, All, I am having trouble to transfer email user account which is saved in MySQL to another server. Here is the detail: I have an old email server which using MySQL to store user account information. The password field uses MySQL ENCRYPT function to save the users password. So if I want

MySQL password issue

2012-10-25 Thread Tim Thorburn
of MySQL which is MySQL 5.5.28 Community Server. I ran the setup choosing Developer install, made a root password, then created two users for Backup and Replication. The install completed successfully, and I was able to start MySQL Workbench logging in as root once. I made a user in Server

RE: MySQL password issue

2012-10-25 Thread Nitin Mehta
Hi Tim, It looks like your '.sql backup file' has changed the password for root user and why it is persisting is perhaps you have data directory outside the install directory. How you correct the problem: Stop the service, start the service with option '--skip-grant-tables', login with root

Re: MySQL password issue

2012-10-25 Thread Tim Thorburn
Not sure how the .sql backup file would have done that, but it seems to be working now. I'll just step away slowly and carry on. Thanks for the help! On 10/25/2012 2:45 AM, Nitin Mehta wrote: Hi Tim, It looks like your '.sql backup file' has changed the password for root user and why

Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Franck Houssen
Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows 7 using Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any password

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Reindl Harald
Am 18.11.2011 23:16, schrieb Franck Houssen: $ mysql -u dummy -p (when I type a real password : dummy, YES... or anything else) ERROR 1045 (28000): Access denied for user 'dummy'@'localhost' (using password: YES) and if you submit the same post every day you will get the same anser

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Basil Daoust
7 using Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any password the connection to the server succeeds). I need client AND server. I followed the on line mysql

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-18 Thread Bruce Ferrell
- mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any password the connection to the server succeeds). I need client AND server. I followed the on line mysql doc. Some comments about the installation / running process that I would underline :I

Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-17 Thread Franck Houssen
Hello mysql-list, I try to install MySQL under Cygwin : I can build (mysql-5.5.17 on windows 7 using Cygwin), I can start and stop the server (only using mysqld.server - mysqladmin fails to connect). I can not connect to the server when I want to use a password (if I don't use any

Re: Can't run MySQL under Cygwin : connect to server at 'localhost' failed (only when using password)

2011-11-17 Thread Reindl Harald
Am 17.11.2011 15:02, schrieb Franck Houssen: $ mysql -u dummy -p (when I hit return as a password = connection OK) Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. mysql show tables; ERROR 1046 (3D000): No database selected mysql quit Bye $ mysql -u dummy -p

Re: mysql server does not recognize user password

2011-10-19 Thread Claudio Nanni
mysql -utim Then mysql SELECT USER(),CURRENT_USER(); Login as root and: delete from mysql.user where user=''; And try again with tim with password. Thanks Claudio On Oct 19, 2011 7:47 AM, Johan De Meersman vegiv...@tuxera.be wrote: Try not passing the password and typing it at the prompt

Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask for the pwd.. then your mysql CLIENT is broken or somehow

Re: mysql server does not recognize user password

2011-10-19 Thread Tim Johnson
* Reindl Harald h.rei...@thelounge.net [111018 23:24]: Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password in the followed dialog Doesn't even ask

Re: mysql server does not recognize user password

2011-10-19 Thread Reindl Harald
Am 19.10.2011 17:45, schrieb Tim Johnson: * Reindl Harald h.rei...@thelounge.net [111018 23:24]: Am 19.10.2011 01:36, schrieb Tim Johnson: try mysql -u tim -p Same error: ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) and enter yur password

mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
using 5.1.57 on Mac Lion. blush I've done this a dozen times, but I've missed something. Am setting up a new mysql installation ... I have granted a user as follows (between lines of asterisks) linus:~ tim$ sudo mysql Password: Welcome

RE: mysql server does not recognize user password

2011-10-18 Thread Mark
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? - Mark -Original Message- From: Tim Johnson [mailto:t...@akwebsoft.com] Sent: woensdag 19 oktober 2011 1:02 To: MySQL ML Subject: mysql server does not recognize user password using 5.1.57 on Mac Lion. blush I've

Re: mysql server does not recognize user password

2011-10-18 Thread Reindl Harald
Am 19.10.2011 01:03, schrieb Tim Johnson: Now when I try to log in with host as localhost, user as tim with 'secret' password: linus:~ tim$ mysql --host=localhost --user=tim --password=secret ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) Huh! did you

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Mark ad...@asarian-host.net [111018 15:14]: Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session? Not originally, but I repeated the grant then issued flush privileges; quit and have the same problem thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Reindl Harald h.rei...@thelounge.net [111018 15:14]: Am 19.10.2011 01:03, schrieb Tim Johnson: Now when I try to log in with host as localhost, user as tim with 'secret' password: linus:~ tim$ mysql --host=localhost --user=tim --password=secret ERROR 1045 (28000): Access denied

Re: mysql server does not recognize user password

2011-10-18 Thread Claudio Nanni
with 'secret' password: linus:~ tim$ mysql --host=localhost --user=tim --password=secret ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password: NO) Huh! did you make flush privileges? Second time around, yes. Same problem you do not specify any password from

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
can be surprised by what you read issuing: SELECT USER(),CURRENT_USER(); linus:~ tim$ sudo mysql Password: . mysql SELECT USER(),CURRENT_USER(); +++ | USER() | CURRENT_USER() | +++ | root@localhost | root@localhost

Re: mysql server does not recognize user password

2011-10-18 Thread Tim Johnson
* Tim Johnson t...@akwebsoft.com [111018 17:47]: Got this... mysql select host,user,password from user; +-+--+---+ | host| user | password

Re: mysql server does not recognize user password

2011-10-18 Thread Johnny Withers
Why does mysql say using password: no? Seems to me the password is not being sent. On Oct 18, 2011 8:37 PM, Tim Johnson t...@akwebsoft.com wrote: * Claudio Nanni claudio.na...@gmail.com [111018 17:02]: FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER etc, Usually

Re: mysql server does not recognize user password

2011-10-18 Thread Johan De Meersman
Try not passing the password and typing it at the prompt. If that works, there's a problem in the parameter parsing. Random thought: could you have a .my.cnf file in your home directory? - Original Message - From: Johnny Withers joh...@pixelated.net To: Tim Johnson t...@akwebsoft.com

Re: MySQL loses password?

2011-06-13 Thread Tim Thorburn
Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found. Trying to use command line produces the error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) The same Access denied for user 'root'@'localhost' (using password: YES) happens when

Re: MySQL loses password?

2011-06-13 Thread Claudio Nanni
'@'localhost' (using password: YES) The same Access denied for user 'root'@'localhost' (using password: YES) happens when trying to use MySQL Workbench 5.2.33 CE. phpMyAdmin gives an error #2000 Cannot log in to the MySQL server. mysql --version returns: mysql Ver 14.14 Distrib 5.5.11

Re: MySQL loses password?

2011-06-13 Thread Andrew Moore
Try starting the server using --skip-grants-table and then resetting the password for the root account. http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-grant-tables I've only seen/heard of the problems you're having with legacy system tables. Did you restore the data

MySQL loses password?

2011-06-12 Thread Tim Thorburn
as root, I got an error number 1045 Access denied for user 'root'@'localhost' (using password: YES). This is odd because I've not changed the root password on my dev machine in years. When I tried to goto a site on this same machine, Apache throws the following message: mysqlnd cannot connect

Re: MySQL loses password?

2011-06-12 Thread Johan De Meersman
If it's recently been upgraded or had an old pre-upgrade backup restored, that's not a major surprise; and surely you won't have ben running mysql on a win7 for several years :-) In brief, mysql changed password encryptions between 4.1 and 5.0, for various reasons. The old password scheme

Re: MySQL loses password?

2011-06-12 Thread Tim Thorburn
There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years, as it is the same password I've used on my dev machines throughout the years. This machine started off as a fresh install of the OS several months ago. The only version of MySQL ever

Re: MySQL loses password?

2011-06-12 Thread Claudio Nanni
This happens when you use an old client / library. Can you try from command line? Also issue: mysql --version Claudio On Jun 12, 2011 3:09 PM, Tim Thorburn webmas...@athydro.com wrote: There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-28 Thread Yves Goergen
On 21.12.2010 11:27 CE(S)T, 杨涛涛 wrote: Maybe you should give a password to MySQL's root. And I think this note will disappear. I would be extremely dumb not to set any password on MySQL's root account at all! Of course (I hope I made that clear before) a password has been set while installing

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-21 Thread 杨涛涛
Maybe you should give a password to MySQL's root. And I think this note will disappear. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/17 Yves Goergen nospam.l

Re: Password Reset

2010-12-17 Thread Johan De Meersman
Change password statements should show up in the binary logs, too, in some form or other. On Thu, Dec 16, 2010 at 9:58 PM, Alejandro Bednarik alejand...@olx.comwrote: SQL injection? Check Apache or whatever log files. On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote: I

Password Reset

2010-12-16 Thread Gary
I recieved a call from a client saying the web site did not work, turns out the database password was reset, and not by me. In looking in the DB after the PW was reset, I could find nothing out of place, although frankly I was not sure what to look for. Is this indicitive of an attack

Re: Password Reset

2010-12-16 Thread Alejandro Bednarik
SQL injection? Check Apache or whatever log files. On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote: I recieved a call from a client saying the web site did not work, turns out the database password was reset, and not by me. In looking in the DB after the PW was reset, I

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-16 Thread Yves Goergen
already asked for a root password during package configuration and I did enter some password there. I just tried to grep my whole filesystem for parts of this message but either grep failed allocating memory (there's plenty left!) or it didn't find the text in a file I could start something with. So I

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-14 Thread Yves Goergen
On 13.12.2010 15:26 CE(S)T, who.cat wrote: try /mysql_bin_path/mysql_secure_installation ! Hope it helpfu! I already followed that path and it doesn't quite help. I've done the checks that the install script does and my installation is secure by those means. But I don't want to install things.

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-11 Thread Yves Goergen
Hi, I find the following line in my syslog events: Daemon Error mysqld PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! followed by a whole lot of notes, advice and web links. I do have set a custom password for root, root is not accessible from remote, the anonymous user does

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Secure the access to the ASP-source file. You *could* encrypt it but then you have to store the key for it somewhere the ASP can access and . Catch

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
Don Thanks for your response. The issue I have is that the password for our database is stored either in the ODBC registry or within our ASP page as plain text. One option I have is to encrypt the password in the database connnection string and have a function with a key in a external file

Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Cheers Neil

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Jay Ess
Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
PM, Jay Ess li...@netrogenic.com wrote: Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any

ODBC MySQL Password as plain text

2009-11-18 Thread Tompkins Neil
Hi The MySQL ODBC connection password is stored as plain text in the Windows registry. What is the best way to overcome this issue - to ensure the password is saved securely Thanks, Neil

Re: How to change root password?

2009-11-16 Thread Michael Wilson
None, of these suggestions worked... Tried the following ways to reset the password: (1) Shut down MySQL via System Preferences pane (2) Placed the following in a text file: UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES; (3 Invoked the following command from

Re: How to change root password?

2009-11-16 Thread John Daisley
(you may have to add -h and -p options to the command above if you are using a non-standard host or port). You should get a mysql prompt, at the mysql prompt type USE mysql; Followed by FLUSH PRIVILEGES; Then type UPDATE user set password = password('new_pass

Re: How to change root password?

2009-11-16 Thread Michael Wilson
Okay, that worked, thank you! -Mike On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote: On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson michaelwilso...@gmail.com wrote: I don't know what the password is for the Unix mysql user... You mean sign in as mysql in the OS X Login Window

How to change root password?

2009-11-15 Thread Michael Wilson
I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new specific password. What

Re: How to change root password?

2009-11-15 Thread Pintér Tibor
Michael Wilson írta: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for root user and wish to either change it back to blank or a new

Re: How to change root password?

2009-11-15 Thread Alexey Mykhailov
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson michaelwilso...@gmail.com wrote: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued

Re: error in instructions to set mysql root password?

2009-09-18 Thread Bennett Haselton
AM 9/15/2009, Bennett Haselton wrote: When I install and start the MySQL server on a new machine, it outputs: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin

error in instructions to set mysql root password?

2009-09-15 Thread Bennett Haselton
When I install and start the MySQL server on a new machine, it outputs: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h sls-ce12p12.dca2

Logins, php, legacy, old password

2009-07-19 Thread Scott Haneda
Hello. It is time for some long overdue service consolidation on my end. I have a production machine ready to go, running the latest MySql 5 series. I have a legacy machine running MySql 4. As you know, version 4 used an older user account password system. I also will be up against some

  1   2   3   4   5   6   7   8   9   10   >