technical 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 Passwo
e database server daemon) is installed to run under the host
>> machine 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
>
pletly bullshit
a) on no sane 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 poin
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
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
system tables that it contains, if they do not exist.
On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller
mailto: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.
n 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 or there is s
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
unning 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 or there is som
ple, mysql)"
Because 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 Pa
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
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
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
> Cu
8
UNIX socket:/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,pa
What 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.mysq
ysql 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 mo
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
I get access denied for
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 ; o
here user='';
> > 2lines got effected
> >
> > after this I can´t connect through command line anymore :
> >
> > ./mysqladmin -u root password
> >
> > I get access denied for user 'root'@'localhost" (using password:'NO&#
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
>>
>> I get access den
#x27;;
> 2lines got effected
>
> after this I can´t connect through command line anymore :
>
> ./mysqladmin -u root password
>
> 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
>
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
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
I get access denied for user 'root'@'localhost" (using pas
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=&#
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:
Hi
> > > | | ericomtxmacbookpro.local |
> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > >
>
mysql> DELETE FROM mysql.user WHERE user='';
mysql> FLUSH PRIVILEGES;
maybe helps?
Cheers
--
Claudio
1.2014 23:59, schrieb Érico:
> > true
> >
> > but please check this out :
> >
> > mysql> Select user, host, password from mysql.user;
> >
> +--+--+---
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
fer-Encoding: quoted-printable
Please 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 den
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 be
ages are in the same computer that mysql
>
> I am not getting password issues.. otherwise I would not connect through
> command line
>
> 2014/1/13 shawn l.green
>
>> On 1/13/2014 1:49 PM, Érico wrote:
>>
>>> Hi
>>>
>>> didn't work
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:
>&
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
emember is that 'localhost' 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 n
27;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'@&#
;
>
> ...
>
>
> in eclipse using jconnector ... I get 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:10
by kernel26' at line 1
...
in eclipse using jconnector ... I get the same error :
when pinging :
java.sql.SQLException: Access denied for user 'root'@'localhost' (using
password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQL
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
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
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
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
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
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)>
>
>
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
> From: Johan De Meersman To:J Gao @
2013-07-19
> > From: "J Gao"
> > 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 ha
- Original Message -
> From: "J Gao"
> 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
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
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 u
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
on 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 S
art 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 li
ws
> 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 serve
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
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 pas
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
&g
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
Am 19.10.2011 17:45, schrieb Tim Johnson:
> * Reindl Harald [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'@'localhos
* Reindl Harald [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
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'
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" wrote:
> Try not passing the password and typing it at
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"
> To: "Tim Johnson&quo
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" wrote:
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually t
* Tim Johnson [111018 17:47]:
Got this...
mysql> select host,user,password from user;
+-+--+---+
| host| user | passw
s.
>
> Sometimes you 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() |
++
ELECT USER(),CURRENT_USER();
try this:
mysql -utim -psecret -h127.0.0.1 -P3306
Regards
Claudio
2011/10/19 Tim Johnson
> * Reindl Harald [111018 15:14]:
> >
> >
> > Am 19.10.2011 01:03, schrieb Tim Johnson:
> > > Now when I try to log in with host as localhost,
* Reindl Harald [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
> > ERRO
* Mark [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 com
http://www.akwebs
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
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.
using 5.1.57 on Mac Lion.
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:
Welc
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 restor
r 'root'@'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.
>
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&#
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" wrote:
> There's been no upgrade or old pre-upgrade on this machine. I say the
> same dev password for years, as it
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 ev
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 pas
tools
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 mes
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
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
> On 14
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 wrote:
> SQL injection? Check Apache or whatever log files.
>
> On Thu, Dec 16, 2010 at 4:17 PM, Gary wrote:
>
> > I recieved a call fr
rver-5.1. It has 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
SQL injection? Check Apache or whatever log files.
On Thu, Dec 16, 2010 at 4:17 PM, Gary 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 could fin
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? Is
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
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 not
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 that
e 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 ?
>>
>>
> Secure the access to the ASP-source file.
> You *could* encrypt it but then you have to store th
PM, Jay Ess 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 an
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
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
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
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
> wrote:
>
>> I don't know what the password is for the Unix mysql user...
>>
>> You mean sign in as mysql in the OS
(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
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 fo
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson
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 issue
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
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
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-pass
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
You should add an account the old software/scripts can use to access the new
MySQL server. Simply add the account then update the password using the
OLD_PASSWORD function.
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_old-password
On Sun, Jul 19, 2009 at 1:03 PM
1 - 100 of 1300 matches
Mail list logo
