I am trying to start mysqladmin from command line. I get this error message:
I don't have replication going. I may have tried it at some point in the past but can't figure out how to get rid of that message and would like to use mysqladmin from cl.

Below is my.cnf
[mysqld]
user = root
pid-file = /var/run/mysqld.pid
port = 3306
tmpdir = /tmp
bind-address = 0.0.0.0
basedir=/usr/local/mysql
datadir=/usr/local/mysql-5.0.77-osx10.4-powerpc/data
sort_buffer_size=2M
default-storage-engine=myisam


[client]
socket=/tmp/mysql.sock

Doesn't say anything about replication.
I have a laptop on the network running Zend Server. I looked at the laptop my.cnf. Didn't see anything about replication there either.

#log-bin=mysql-bin

# binary logging format - mixed recommended
#binlog_format=mixed
#enable full log query
log=/var/log/mysqldquery.log
#log slow queries only
#log-sloq-queries=/var/log/mysql/mysql-slow.log
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/zend/mysql/data
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/zend/mysql/data
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

Where can I fix that setting so I can use mysqladmin?
TIA,
Janis Rough

On 7/13/2012 5:48 PM, jans wrote:
Your command is trying to start replication on a slave. Since this is
not configured as a slave, the message is correct.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On 13-07-2012 23:48, jans wrote:
....

What do you want to use mysqladmin for?
You will get a list op option if you just type 'mysqladmin'

'mysqladmin start' tries to start a slave

If you want to start the client you should type:
mysql -u root -p

On Saturday, July 14, 2012 1:49:50 AM UTC-7, Luuk wrote:

What I want to do is run sql queries on my laptop over TCP/IP to access my network desktop running MySQL community. I have the MySQL Server set outside the firewall for testing. I tried the mysql command using the IP number and also using localhost, see below. Is it an access issue? I don't know what you mean start the client. I don't know which client? On my laptop I have Zend Server Community. On my laptop I have MySQL server but I want to access the other computer from the laptop. Is the solution to this to install MySQL client on my laptop? Does this interfere with Zend Server? I just really want to do this with the command line. Thanks,




janis-roughs-macbookpro55:bin jr$ /usr/local/zend/mysql/bin/mysql -h XX.XX.XX.XX -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'XX.xxx.X.XX' (using password: YES)

janis-roughs-macbookpro55:bin jr$ /usr/local/zend/mysql/bin/mysql -h 127.0.0.1 -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
janis-roughs-macbookpro55:bin jr$

It is outside the firewall for testing purposes. Thanks,

On Saturday, July 14, 2012 1:49:50 AM UTC-7, Luuk wrote:
Thanks for your reply. I got the answer. I installed MySQLWorkbench. FOr some reason MySQLAdministrator wasn't working. I guess you can't use the command line on a remote computer.

On 7/16/2012 2:14 PM, jans wrote:
Sure you can. I do it all the time.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

jans <janis.rough (AT) gmail (DOT) com> wrote:
This is an (expected) problem with MySQL accounts. Read on below.

This will of course not work, because 127.0.0.1 is your laptop
and the MySQL server is not running there. If you run this on
your desktop (but without the -p) then it should however work.


As of MySQL accounts: MySQL uses its own privilege system.
Means: user names and passwords used by the MySQL server are
normally *not* the same as for the operating system.

MySQL comes with two accounts pre-installed:

1. root@localhost, root (AT) 127 (DOT) 0.0.1, root (AT) your (DOT) host.name
without a password, has all(!) permissions
2. (anybody)@localhost, (anybody)@your.host.name
no password, permissions for the `test` and `test_*` databases
(anybody) means that any user name will do. On unix systems your
system account name is used when you don't give a user name.

The very first step after installing the MySQL server is to
set a password for the root account and optionally remove the
anonymous account for the test* databases:

http://dev.mysql.com/doc/refman/5.5/...rivileges.html

In fact this step is so important, that many packagers include it
in the installation procedure. You should know yourself if you've
been asked for a MySQL password during installation.

Fact #1: there are no pre-installed MySQL accounts to access MySQL
from a remote machine. This is intentional.

Conclusion: you have to create new MySQL account(s) to access MySQL
(running on your desktop) over the network (from your laptop).
In order to do so, you must connect to MySQL as user root from the
machine where the MySQL server is running (your desktop).

Please read and understand:

http://dev.mysql.com/doc/refman/5.5/...anagement.html

I won't tell you the exact commands because it is very important
that you understand this stuff.


Hints:

- for safety reasons you should not allow root access to the MySQL
server over the network.

- for remote access specify a host name or ip address for the machine
where the MySQL client runs. Do not use wildcards here!

- any MySQL account should have the minimum of privileges needed.
No application (i.e. PHP script) will ever need the SUPER privilege!

- keep in mind that the MySQL network protocol is effectively clear
text (except the login as such). If your network is insecure,
configure SSL as described in the MySQL manual.


XL

On 7/16/2012 6:05 PM, Axel Schwenke wrote:
Axel, you forget who you're responding too..

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================