[Shadow]

In MySql a user id consists of two parts: a user name and a host name ('my_user_name'@'host_name'). This message means that your host is not allowed to connect to the given MySql server. If it is run by an ISP (or any third party) and your IP address changes every time you connect to the net (i.e. dial-up), then you have to ask the operators to grant 'your_user_name'@'%' access. If you have a fixed IP, then you may ask them to grant access to 'your_user_name'@'ypur_ip'. In case you can manage the users, then you may be able to do it yourself.

[Shadow]

You may want to check chapter “A.2.2 MySQL server has gone away Error” of MySql's manual as well.

[Shadow]

I've encountered the same error under two conditions:

1. MySql server was restarted while I was still logged in

2. Wanted to send a too large packet to MySql and sometimes got this warning (along with packet too large…).

[Shadow]

It is a MySql parameter.

Quote:

A communication packet is a single SQL statement sent to the MySQL server or a single row that is sent to the client. When a MySQL client or the mysqld server gets a packet bigger than max_allowed_packet bytes, it issues a Packet too large error and closes the connection.

Try setting max-allowed-packet parameter in the my.ini or my.cnf file to a larger value. In 3.23 the max allowed value is 16MB, while from 4.* on the physical memory of your machine limits its size.

[Shadow]

Indices are listed right after the field definitions in the CREATE TABLE command.

[Shadow]

MySql recognizes dates in various formats, if you are lucky enough, then will transform your data from mm/dd/yyyy format to its own, provided you don't feed date columns as varchar to MySql. It works for me via ADO…

[Shadow]

What is the question? If you want to find a complete end-user interface for MySql designed for data entry, I must disappoint you: there is no such general tool, you have to write your own. The available front-ends are admin tools, although you may use them for data entry. SQLyog might have such capabilities in the distant future.

Connections made via ODBC are subject to MySql's privilege system. If a product (third party or not) connects via ODBC and the access rules don't or seemingly don't apply to it, then something is terribly wrong vith that app, or with the configuration of MySql, or worse, with MySql…

[Shadow]

Dear gluegun,

What if you read chapter 4.2 “General Security Issues and the MySQL Access Privilege System” and chapter 4.3 “MySQL User Account Management” first? These two chapters describe the privilage system in detail, even the structure of the mysql db is explained.

There are two ways to add a user to a server:

– by explicitly issuing “INSERT INTO mysql.user (Host,User,Password…) VALUES ('%','my-user-name',MD5('my_password'),…); FLUSH PRIVILAGES;” SQL commands (… means the rights that accept values 'N' and 'Y'; MD5 is a MySql function that creates MD5 hash of the parameter)

– by issuing a GRANT command: GRANT SELECT, INSERT… ON my_db_name.* TO 'my-user-name'@'%';

If you specify ' around your username, then any characters are allowed, but _,@ and % are cautioned against; otherwise these three characters are not allowed!

[Shadow]

I forgot to list '@' in the forbidden characters' list.

[Shadow]

You should check out MySql manual about GRANT and REVOKE syntax and the chapters about security first!

You should ask your ISP to grant access to 'your_user_name'@'%'. '%' means that you can connect from any host. As long as you cannot login to MySql, you cannot create any db.

[Shadow]

As far as I'm concerned, usernames do not have to be alphanumeric (any character is allowed but '%' and '_'), unless your ISP changed the rules somehow. And even if it were, then providing '%' as host name should be sufficent.

[Shadow]

You need to do it via SQL command if possible.

[Shadow]

Or just need to refresh the object browser by pressing F9 after the import…

[Shadow]

Wrong. It shows the first 5000 records INCLUDING the first one. The reason for the limit clause is not to query a table fully that has millions of rows, but 5000 is still a fairly large number. If you want to use a different limit clause, then adjust the limit clause to fit your needs – there is no way to change this parameter of the default query.

[Shadow]

Hi Bobnz,

Imported your db on Winnt Workstation (SP6) with Access 97 to MySql 4.0.13 and 4.1-alpha without any problem. It succeeded on Win2K professional with Access 2000 as well. Perhaps you should try with a newer version of MySql. Could you tell the name of the table that halts the import?

[Author]

Posts