Can"t execute a GRANT in order to connect from outside

Hello,

First time I use a Windows MySQL Server :

I can't connect from outside and locally, I can't execute a GRANT
statment in order to get a user who has this right. I get a 1064 error
when I'm trying to execute :

GRANT ALL ON *.* TO me IDENTIFIED BY 'password'.

Any idea ?

Thanks !

Stephane

Here is my conf file :

# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
skip-innodb
bind-address=127.0.0.1
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following rows if you move the MySQL distribution to
another
# location
basedir = C:/Program Files/EasyPHP1-7/mysql/
datadir = C:/Program Files/EasyPHP1-7/mysql/data/


# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:100M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

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

[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[mysqlhotcopy]
interactive-timeout


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Can"t execute a GRANT in order to connect from outside

You forgot to specify the hostname. You need to specify a hostname or
else MySQL will default to 'localhost' which allows ONLY connections
from the local machine. Your query should look something like:

GRANT ALL ON *.* to user_name@'%' IDENTIFIED BY 'password';

The % tells MySQL to allow connections from everything that is not
localhost. Cheers.

Armando

Stéphane Pinel wrote:
> Hello,
>
> First time I use a Windows MySQL Server :
>
> I can't connect from outside and locally, I can't execute a GRANT
> statment in order to get a user who has this right. I get a 1064 error
> when I'm trying to execute :
>
> GRANT ALL ON *.* TO me IDENTIFIED BY 'password'.
>
> Any idea ?
>
> Thanks !
>
> Stephane
>
> Here is my conf file :
>
> # This will be passed to all mysql clients
> [client]
> #password=my_password
> port=3306
> #socket=MySQL
>
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
>
> # The MySQL server
> [mysqld]
> skip-innodb
> bind-address=127.0.0.1
> port=3306
> #socket=MySQL
> skip-locking
> set-variable = key_buffer=16K
> set-variable = max_allowed_packet=1M
> set-variable = thread_stack=64K
> set-variable = table_cache=4
> set-variable = sort_buffer=64K
> set-variable = net_buffer_length=2K
> server-id = 1
>
> # Uncomment the following if you want to log updates
> #log-bin
>
> # Uncomment the following rows if you move the MySQL distribution to
> another
> # location
> basedir = C:/Program Files/EasyPHP1-7/mysql/
> datadir = C:/Program Files/EasyPHP1-7/mysql/data/
>
>
> # Uncomment the following if you are NOT using BDB tables
> #skip-bdb
>
> # Uncomment the following if you are using Innobase tables
> #innodb_data_file_path = ibdata1:100M
> #innodb_data_home_dir = c:\ibdata
> #innodb_log_group_home_dir = c:\iblogs
> #innodb_log_arch_dir = c:\iblogs
> #set-variable = innodb_mirrored_log_groups=1
> #set-variable = innodb_log_files_in_group=3
> #set-variable = innodb_log_file_size=5M
> #set-variable = innodb_log_buffer_size=8M
> #innodb_flush_log_at_trx_commit=1
> #innodb_log_archive=0
> #set-variable = innodb_buffer_pool_size=16M
> #set-variable = innodb_additional_mem_pool_size=2M
> #set-variable = innodb_file_io_threads=4
> #set-variable = innodb_lock_wait_timeout=50
>
> [mysqldump]
> quick
> set-variable = max_allowed_packet=16M
>
> [mysql]
> no-auto-rehash
> # Remove the next comment character if you are not familiar with SQL
> #safe-updates
>
> [isamchk]
> set-variable = key_buffer=8M
> set-variable = sort_buffer=8M
>
> [myisamchk]
> set-variable = key_buffer=8M
> set-variable = sort_buffer=8M
>
> [mysqlhotcopy]
> interactive-timeout
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org