Hi Ian Thanks!
Your advice worked.I have another problem.I stopped the service from the
services shortcut in the Administrative tools.then according to to the
reference manual to start the server for the first time the command to run
is given as C:\>"C:\Program Files\MySQL\MySQL Server 5.0\bin\
Hi Varuna,
The problem looks like it is with the command you issued. The correct
syntax is:
mysqladmin -uroot -p shutdown
then supply root password.
Without giving the -uroot argument, it doesn't know that you are trying
to log in as the root user, which is why it is telling you that access
is
Hi Varuna,
I think you're missing the "-u" option (User for login if not current user.)
Try: "mysqladmin" -u root -p shutdown
(-p without a value indicates to prompt for a password from the terminal.)
Andy
Varuna Seneviratna wrote:
I am using WinXP.I am wanted to shutdown MySQL service from
Varuna Seneviratna írta:
I am using WinXP.I am wanted to shutdown MySQL service from the command line
and ran the command "mysqladmin" -p root shutdown next the root password was
asked for,I entered the correct password, when I entered the password the
below displayed error was the result
mysqla
Marc MENDEZ wrote:
Hi,
For mysqladmin, this parameter does not exist. I'll try anyway by
forcing password and user on the command line.
I'll check tomorrow.
Sure it does.
$ mysqladmin --help | grep extra
--defaults-extra-file=# Read this file after the global files are read
--
MySQL Gener
Marc MENDEZ wrote:
Hi,
I work under Mandrake 10.1
First, I have a .my.cnf, which works quite well, since I can enter mysql
without entering any password.
Even mysqladmin works !
But, I have a batch process run by crontab as root, which tests if mysql
is running (mysqladmin version --silent).
Michael Stassen wrote:
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as
per the instructions in the manual.
My proble
Alfred Vahau wrote:
According to the Mysql online manual, to reset a root password one
procedure is to issue the command:
./mysqladmin --skip-grant-tables
to have full access to the database and update the root password as per
the instructions in the manual.
My problem is when I issue the comm
Hello.
MySQL team verified this issue, but they've said that this is rather
a feature request, not really a bug. See:
http://bugs.mysql.com/bug.php?id=13032
Jason Pyeron <[EMAIL PROTECTED]> wrote:
> Thanks Michael,
>
> but it now seems that on prepared selects, the values are still
Thanks Michael,
but it now seems that on prepared selects, the values are still place
holders, whilst on prepared inserts they are substituted in.
Does anyone know how to address this issue?
+-+---++---+-+--+--+--
You can log on to your mysql server and run:
show full processlist;
That should give you what you are looking for.
-m
On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote:
mysqladmin is truncating the output, how can i disable this?
or is there a better way to examine what the serer is executing
Hello.
Have you changed InnoDB log file sizes? See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Manual says that you have to stop mysql, then change the parameter in my.cnf,
then I moved to another directory the log file just to be cautious, and then
restarted mysql
Hamm [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 8:06 AM
To: Nguyen, Phong
Cc: mysql@lists.mysql.com
Subject: Re: mysqladmin Shutdown fail
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong < [EMAIL P
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> error 'Access denied for user 'root'@ 'loc
Do you have any root password set? If so, you should mention -p option in
the command. The command should be of the following :
c:\mysql\bin\mysqladmin -u root shutdown -p
Which will ask you to enter the root password, else you can type your
password along with the -p option as follows :
c:\
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote:
>
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> er
Try enclosing 2521570862 in single quotes on the command line. It's
just a guess but it might be bash overflowing that number and not
mysqladmin.
-Eric
On 4/18/05, Marvin Wright <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Our database has been running for some time and it had some threads on it
> that
[EMAIL PROTECTED] wrote:
> We have installed a mysql database on our our server. The data and log
> files are stored on an external SCSI disk array which is connected to
> our server using FC cable connected to SCSI port. The mysql process is
> running on the local machine but the data and logs a
o:[EMAIL PROTECTED]
> Sent: Wednesday, July 07, 2004 10:07 PM
> To: Ravi T Ramachandra (WT01 - EMBEDDED & PRODUCT ENGINEERING SOLUTIONS)
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysqladmin shutdown command hangs
>
>
> On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote:
>
> > When ther
Are you able to communicate with the database server at all. Login, query,
etc.?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/7/04 11:38 PM
Subject: mysqladmin shutdown command hangs
Hello:
We are using mysql 4.0.17 on Linux
We have installed a mysql data
Ramachandra (WT01 - EMBEDDED & PRODUCT ENGINEERING SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: mysqladmin shutdown command hangs
On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote:
> When there is an accidental communication breakdown between disk array
> and server on which mysql process is ru
On Thu, 8 Jul 2004 [EMAIL PROTECTED] wrote:
> When there is an accidental communication breakdown between disk array
> and server on which mysql process is running (e.g, pulling out FC
> cable), this is being detected by our scripts and then we are trying to
> shutdown the mysql process by using m
Hi Tom,
You can't. MySQL's own thread ids are sequential. The OS pids are
random. There's no connection between them. Besides, mysqld is really
only running in a single "real" process, it's just that LinuxThreads
shows each thread as a "process."
Matt
- Original Message -
From: "To
Seems like I forgot to post to the list again. O.K this one is for the record
;-)
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 13:54、あなたは書きました:
> Hi Saravanan,
>
> Thats a simple question. You have to specify a username and a password when
> connecting to the mysql server. I guess thats similar t
Check the sysntax!
It should be
mysqladmin -u root -p shutdown (If u r shutting down the server)
You should provide the password if you have one for the root user.
>>> Saravanan Kulandaivelu <[EMAIL PROTECTED]>
7/23/2003 3:21:59 PM >>>
Hi,
I am getting the following error:
mysqladmin: connect
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for "lost password" "mysql"
Thanks for the tip about how to proceed.
Just so we don't lose track here, the point of the bug we're reporting
is that m
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: mysqladmin -u root -h myhost password 'new-password' fails
Karl,
yes, same problem here.
Looking at the user table it seems the entry is there,
but mysqladmin failed. I also attempted to set by hand
the password using update table.
Karl,
yes, same problem here.
Looking at the user table it seems the entry is there,
but mysqladmin failed. I also attempted to set by hand
the password using update table. The update succeeded,
but then when I used mysql -u root -h -p
and
typed in the password, mysql also denied access saying
t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 18 Mar 2003, Andrew Braithwaite wrote:
> Anyone know why "mysqladmin processlist" is not showing the host that is
> connected, but instead is showing the following in v4.0.12:
>
> <>
> +-+-+--+--+---
Anyone else notice this, or is it just me?
Andrew
-Original Message-
From: Andrew Braithwaite
Sent: Tuesday 18 March 2003 23:05
To: 'R. Hannes Niedner'; MySQL Mailinglist
Subject: RE: mysqladmin processlist = weird in version 4.0.12
Hi,
I do understand what you're s
erver
that is connecting. The "/etc/hosts" file is fine and is the same as it was
before
Bug or feature?
Cheers,
Andrew
-Original Message-
From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 18 March 2003 22:48
To: Andrew Braithwaite; MySQL Mailinglist
Subject:
It says in the change log that it added the port to make it easier to see
where the connection is coming from. 146.101.143.72:48753 gives you a lot
more information than "host1"
>From the release announcement --
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to m
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of
messages ago):
Functionality added or changed:
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to make it easier to know from which client the request
originated.
I guess whenever th
Hello again,
Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a
'mysqladmin --help'. Grepping the source found it.
- GW.
>Date: Wed, 29 Jan 2003 11:19:06 +1100
>To: [EMAIL PROTECTED]
>From: Guy Waugh <[EMAIL PROTECTED]>
>Subject: 'mysqladmin slave-st(art|op)'
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
On Friday 20 December 2002 15:31, Imran Khan wrote:
> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
slickmik,
Thursday, November 21, 2002, 6:58:18 PM, you wrote:
saedodedn> Description:
saedodedn> When mysql is installed via linux rpm file, it does not install
saedodedn> mysqladmin command?
saedodedn> How-To-Repeat:
saedodedn> just install mysql from redhat linu
aman,
Saturday, November 02, 2002, 6:18:58 PM, you wrote:
am> If I have an old copy of Mysql on the system and want to uninstall that, how
am> would I make sure that all the database associated should get deleted, or do
am> I do it manually?
If you uninstall MySQL server, data directory will not
t;aman mysql" <[EMAIL PROTECTED]>; "mysqlusers"
<[EMAIL PROTECTED]>
Sent: Saturday, November 02, 2002 8:31 AM
Subject: Re: mysqladmin missing
>
> mysqladmin comes with mysql-server-X.XX.XX-X.rpm, me think you installed
> mysql-X.XX.XX-X.rpm only
>
> Try thi
mysqladmin comes with mysql-server-X.XX.XX-X.rpm, me think you installed
mysql-X.XX.XX-X.rpm only
Try this command to make sure : rpm -qa | grep mysql
Then, get the mysql-server RPM here :
http://www.rpmfind.net/linux/rpm2html/search.php?query=mysql-server&submit=S
earch+...&system=redhat&arch=
On Friday, November 1, 2002, at 05:39 PM, [EMAIL PROTECTED] wrote:
Hi,
Hello.
I'm new to mysql and I'm reading a pdf book on how to change the
default
password for admin to my own choosing.
The problem is once I do the steps of -password mypass it comes back
with
an error message.
Try to do
Tom,
Wednesday, October 30, 2002, 10:01:50 PM, you wrote:
TR> I just got a Red Hat 7.3 box up and running and have mysql on it...I've
TR> noticed that when using mysqladmin it doesn't prompt me for a password
TR> like other boxes that I've been on(ones I didn't build) have...is there
TR> a way t
Eric Lamendola wrote:
> Hey,
>
> I thought you could just use
>
> mysqladmin refresh -pPASSWORD -- or
> mysqladmin reload -pPASSWORD
>
> To kickstart logging again?
>
> If not - hey, what do I know
>
> Eric Lamendola
>
Yeah that only restarts the binary log. I like to have a human-readable
log
Hey,
I thought you could just use
mysqladmin refresh -pPASSWORD -- or
mysqladmin reload -pPASSWORD
To kickstart logging again?
If not - hey, what do I know
Eric Lamendola
At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote:
>Hi all.
>
>I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or
it means access denied. either cos you dont have permissions in your mysql
privilege table or your password is wrong. did you supply a valid username
and password in the command string?
- Original Message -
From: "Dave Reinhardt" <[EMAIL PROTECTED]>
To: "MySql Support" <[EMAIL PROTECTED]
Eivind,
Tuesday, June 18, 2002, 11:31:19 AM, you wrote:
EAS> Does anybody know a little more about what the info in mysqladmin 'status'
EAS> tells about the mysqld?
EAS> This may sound a little blunt, and maybe I could have found it in the manual
EAS> somewhere. But still, I would like to get a f
eq99083,
Monday, April 15, 2002, 9:59:39 PM, you wrote:
e> Please,
e> can anyone tell me where is the source code for MySQLAdmin.exe for Win32?
You can download the source distribution of MySQL for Windows and take
a look at folder 'Client' ...
e> Thank you
--
For technical support contrac
At this 04:57 16/04/02 +0100 [EMAIL PROTECTED] told us all something
interesting :-
> >>Where can I d/load phpMyAdmin from ?<<
>
>http://sourceforge.net/projects/phpmyadmin/
Thanks...
Hmm - Ive d/loaded it, but having problems after problems
When i go to :-
http://kwister.dns2go.com/phpad
ay, April 11, 2002 12:22 PM
Subject: Re: mysqladmin
> Hisseine,
> Thursday, April 11, 2002, 7:13:58 PM, you wrote:
>
> HD> I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm
> HD> I did the installation on linux redhat 7.2, everything is ok, but I
can't
> HD>
Hisseine,
Thursday, April 11, 2002, 7:13:58 PM, you wrote:
HD> I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm
HD> I did the installation on linux redhat 7.2, everything is ok, but I can't
HD> locate the msqladmin command.
HD> I try find command as root but nothing in the result.
Okan,
Thursday, April 11, 2002, 12:52:04 PM, you wrote:
OC> When I execute mysqladmin drop database database_name it drops the database
OC> without asking for a user or password. How are the security features are set
OC> about mysqsladmin?
Check permissions on databases. Looks like the anonymous
From
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Default_privileges
The MySQL root user is created as a superuser who can do anything.
Connections must be made from the local host. Note: The initial root
password is empty, so anyone can connect as
Sinisa Milivojevic writes:
> Yes, that is so.
>
> But you do not have to restart MySQL. Just run:
>
> FLUSH HOSTS
D'oh. I should've read the manual before posting. Sorry.
To those who hasn't seen it already, I wish to point out that
section 5.5.5 has some useful information about MySQL's host
Carl Troein writes:
>
>
> Does this mean that mysqld keeps its own cache of hostnames,
> and that it never checks to see if it has gone stale? If so,
> one might have to shut down and restart the server at regular
> intervals (once an hour or whatever) if one relies on host
> names (maybe not a
Sinisa Milivojevic writes:
> > We found that, if you alter the permission tables (user) & /etc/hosts
> > (so that it can do IP-address-to-hostname mapping for the hosts named in
> > "user") & say "mysqladmin reload", mysql doesn't pick up the changes -
> > you have to shut it down totally & rest
[EMAIL PROTECTED] writes:
> >Description:
> We found that, if you alter the permission tables (user) & /etc/hosts
> (so that it can do IP-address-to-hostname mapping for the hosts named in
> "user") & say "mysqladmin reload", mysql doesn't pick up the changes -
> you have to shut it down totally &
"Wells, Kenneth L" wrote:
> Please help
>
> I'm at the end of my rope...
>
> I just ran a script to create databases in my SQl server, it runs fine
>
> When it completes it says remember to set a password for the mysql root
> user!
>
> I entered this?
>
> /usr/local/mysql/bin/mysqladmin -u ro
[EMAIL PROTECTED] writes:
> mysqladmin: error while loading shared libraries: libgcc_s.so.1:
> cannot load shared object file: No such file or directory
Make sure /usr/local/lib is in your /etc/ld.so.conf, and
then run ldconfig. Another solution is to have LD_LIBRARY_PATH
include that director
Sorry for that - Recompiled and everything works as expected.
ta.
-Original Message-
From: Mark Cance [mailto:[EMAIL PROTECTED]]
Sent: 19 October 2001 14:07
To: [EMAIL PROTECTED]
Subject: mysqladmin
Hi,
I know I'm probably doing something really dumb but has anyone got any ideas
why I
At 11:54 AM -0600 8/28/01, root wrote:
> >Description:
>I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm.
That's the RPM that contains the server. mysqladmin is a client.
Install the client RPM.
>The user instructions at the end of the rpm -i ./*.rpm command
>proscripbed the use
As far as I know mysql-xx-xx-xx-xx-xx-tar.gz comes with both mysqlclient and
mysqladmin, check where those
files are located (locate, find / -name -print) and check that they are
in your path (/etc/profile for global settings). Then give it one more try or
hit the Doc's :)
Martin östlund
Steve
http://www.mysql.com/doc/C/o/Connecting.html
Scroll to the bottom, where it describes adding your password to .my.cnf in
your home directory.
> I actually wanted to disable passwords completely.
>
> so when I type mysql the mysql> comes up.
>
> Tom
-
I actually wanted to disable passwords completely.
so when I type mysql the mysql> comes up.
Tom
- Original Message -
From: "Zak Greant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 11:57 PM
Subject: Re: m
Use the -p option to allow you to enter the password.
--zak
- Original Message -
From: "Tom Gao" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 12:46 AM
Subject: mysqladmin
> Hi guys
>
> I wanted to setup password for mysql access so I typed 'mysqladmin
> mypass
What is the command you are using to change password?
- Original Message -
From: "Zen Woo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 22:16
Subject: mysqladmin
> Hi,
>
> mysqladmin: unable to change password; error: 'You are using MySQL as an
> anonymous
68 matches
Mail list logo
