mysql-nt config issues

--0-1097610154-1106688421=:4873
Content-Type: text/plain; charset=us-ascii

Hello, I'm running Windows 2000 Professional 5.00.2195 SP 4, trying to configure MySQL 3.23.58, but I keep getting error messages when I try to create a test database.

In MySQL Admin screen, I saw that the driver 3.51 was not found, so I downloaded the odbc driver 3.51, rebooted, etc. I no longer see that up in the Admin panel; the driver is located but I'm still getting a "Not Found" status for MyODBC.

My console keeps displaying this error:

C:\mysql\bin>mysqladmin create testDB
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost'
to database 'testdb''

I've tried reconfiguring "my.cnf":

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# 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]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
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:/mysql/
datadir = c:/mysql/data/

# Uncomment the following if you are NOT using BDB tables
skip-bdb
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=384M
#set-variable = bdb_max_lock=100000
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
#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=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout

I've pored through the html manual that was bundled with MySQL, my.ini setup seems good. I'm logging into the system with Administrator priveleges. I can't figure out why this isn't working. Any help would be greatly appreciated.

Thanks,
- Rob


---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
--0-1097610154-1106688421=:4873--

Re: mysql-nt config issues

At 13:27 -0800 1/25/05, k . wrote:
>Hello, I'm running Windows 2000 Professional 5.00.2195 SP 4, trying
>to configure MySQL 3.23.58, but I keep getting error messages when I
>try to create a test database.
>
>In MySQL Admin screen, I saw that the driver 3.51 was not found, so
>I downloaded the odbc driver 3.51, rebooted, etc. I no longer see
>that up in the Admin panel; the driver is located but I'm still
>getting a "Not Found" status for MyODBC.
>
>My console keeps displaying this error:
>
> C:\mysql\bin>mysqladmin create testDB
>mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
>'@localhost'
> to database 'testdb''

You're connecting as the anonymous user, which doesn't have privileges
for anything but the "test" database. Try connecting as root instead.

>
>I've tried reconfiguring "my.cnf":

It's not a my.cnf issue. It's an issue of connecting to the server
using a MySQL account that have sufficient privileges.


>I've pored through the html manual that was bundled with MySQL,
>my.ini setup seems good. I'm logging into the system with
>Administrator priveleges. I can't figure out why this isn't
>working. Any help would be greatly appreciated.

It doesn't matter if you're logged in with Administrator privileges.
Windows privileges don't have anything to do with MySQL account privileges.

For more information, have a look at the the sections in the administration
chapter of the MySQL manual that cover how the grant system works.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
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: mysql-nt config issues

For one thing, you should probably hold off trying to get the ODBC
Driver to work, the MySQL binaries do not use this, and it isn't
necessary for MySQL to run properly.

What your current goal should be is to set up the mysql database (it
handles privileges) so you can log on. It appears that you've already
done *some* of that, because otherwise you should have been able to
login without specifying a username and password.

Try running the mysql command (in the C:\mysql\bin dir) to log in.

mysql

or

mysql -uroot

or

mysql -uroot -p


The first 2 should work with the default state of the privileges tables.

Once you are able to login with the mysql command, you'll probably find
you'll be able to do everything else.

k . wrote:

>Hello, I'm running Windows 2000 Professional 5.00.2195 SP 4, trying to configure MySQL 3.23.58, but I keep getting error messages when I try to create a test database.
>
>In MySQL Admin screen, I saw that the driver 3.51 was not found, so I downloaded the odbc driver 3.51, rebooted, etc. I no longer see that up in the Admin panel; the driver is located but I'm still getting a "Not Found" status for MyODBC.
>
>My console keeps displaying this error:
>
> C:\mysql\bin>mysqladmin create testDB
>mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost'
> to database 'testdb''
>
>I've tried reconfiguring "my.cnf":
>
>[mysqld]
>basedir=C:/mysql
>datadir=C:/mysql/data
># Example mysql config file.
># Copy this file to c:\my.cnf to set global options
>#
># One can use all long options that the program supports.
># Run the program with --help to get a list of available options
># 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]
>port=3306
>#socket=MySQL
>skip-locking
>set-variable = key_buffer=384M
>set-variable = max_allowed_packet=1M
>set-variable = table_cache=512
>set-variable = sort_buffer=2M
>set-variable = record_buffer=2M
>set-variable = thread_cache=8
># Try number of CPU's*2 for thread_concurrency
>set-variable = thread_concurrency=8
>set-variable = myisam_sort_buffer_size=64M
>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:/mysql/
>datadir = c:/mysql/data/
>
># Uncomment the following if you are NOT using BDB tables
>skip-bdb
># Uncomment the following if you are using BDB tables
>#set-variable = bdb_cache_size=384M
>#set-variable = bdb_max_lock=100000
># Uncomment the following if you are using Innobase tables
>#innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
>#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=256M
>set-variable = sort_buffer=256M
>set-variable = read_buffer=2M
>set-variable = write_buffer=2M
>[myisamchk]
>set-variable = key_buffer=256M
>set-variable = sort_buffer=256M
>set-variable = read_buffer=2M
>set-variable = write_buffer=2M
>[mysqlhotcopy]
>interactive-timeout
>
>I've pored through the html manual that was bundled with MySQL, my.ini setup seems good. I'm logging into the system with Administrator priveleges. I can't figure out why this isn't working. Any help would be greatly appreciated.
>
>Thanks,
> - Rob
>
>
>---------------------------------
>Do you Yahoo!?
> Yahoo! Search presents - Jib Jab's 'Second Term'
>
>


--
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