distal-attribute
distal-attribute
distal-attribute
distal-attribute

Issue with Create new - Table copy

martinjl posted 8 months ago in General
"Create new - Table copy" doesn't work as "user" name gets truncated (last 6 characters).... SQL Error (1044): Access denied for user 'dbm.camping-cana'@'%' to database 'information_schema'.
ansgar posted 8 months ago
What's the previous SQL code you see in the SQL log panel at the bottom?
martinjl posted 8 months ago
date/time : 2014-02-18, 08:20:13, 237ms
computer name : JL-PC
user name : JL
registered owner : JL / Microsoft
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 4 days 21 hours
program up time : 11 minutes 29 seconds
processors : 8x Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
physical memory : 10198/16347 MB (free/total)
free disk space : (C:) 1431.80 GB
display mode : 2560x1440, 32 bit
process id : $2958
allocated memory : 104.16 MB
largest free block : 8185.34 GB
executable : heidisql.exe
exec. date/time : 2014-01-25 11:34
version : 8.3.0.4694
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $151cbb27, $3b27b1cb, $3b27b1cb
exception number : 5
exception class : EDatabaseError
exception message : SQL Error (1044): Access denied for user 'dbm.camping-cana'@'%' to database 'information_schema'.
ansgar posted 8 months ago
I meant the *SQL code* which is displayed in the log panel. Please post the last 5 lines of SQL here.
martinjl posted 8 months ago
/* 2014-02-18 14:14:26 [] */ /* Writing to session log file now: C:\Users\JL\AppData\Roaming\HeidiSQL\Sessionlogs\000002.log */
/* 2014-02-18 14:14:28 [CampingCanada] */ /* Connecting to megasqlservers.com via MySQL (TCP/IP), username dbm.camping-canada.com, using password: Yes ... */
/* 2014-02-18 14:14:28 [CampingCanada] */ /* Connected. Thread-ID: 19005725 */
/* 2014-02-18 14:14:28 [CampingCanada] */ SHOW STATUS;
/* 2014-02-18 14:14:28 [CampingCanada] */ SHOW VARIABLES;
/* 2014-02-18 14:14:28 [CampingCanada] */ USE `Campgrounds_camping-canada_com`;
/* 2014-02-18 14:14:28 [] */ /* Entering session "CampingCanada" */
/* 2014-02-18 14:14:28 [CampingCanada] */ SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='Campgrounds_camping-canada_com';
/* 2014-02-18 14:14:28 [CampingCanada] */ /* SQL Error (1044): Access denied for user 'dbm.camping-cana'@'%' to database 'information_schema' */
/* 2014-02-18 14:14:28 [CampingCanada] */ SHOW TABLE STATUS FROM `Campgrounds_c

ansgar posted 8 months ago
usernames in mysql are restricted to 16 characters, but you specified a longer one which must fail when connecting. Just try out connecting normally to that session.
martinjl posted 8 months ago
I am able to connect (open a session) using the 22 char user defined in session manager! Why is it ok there & not on copy-table?
ansgar posted 8 months ago
By "copy-table" you mean the SQL export dialog, or the "Create new" > "Table copy" thing?

That message "Access denied for user 'dbm.camping-cana'@'%' to database xyz" is generated by the server.

You probably somehow managed to create a username longer than 16 chars and now you're running into problems here. Please try to shorten your username to max 16 chars.

Also, have a look into the mysql.user table. There is a "User" column in that table. Watch out for its maximum length in the table designer, should be 16. Then look into the data of that table, if your user really has more than 16 chars.
martinjl posted 6 months ago
Even with user of 16 char, same error!
ansgar posted 6 months ago
And the error is happening again in this line?

SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='Campgrounds_camping-canada_com'

Please login to leave a reply, or register at first.