Bug #7618 | Fresh install MySQL has mysql.user_info table in latin1_swedish_ci | ||
---|---|---|---|
Submitted: | 2 Jan 2005 14:51 | Modified: | 17 Mar 2005 16:26 |
Reporter: | Paul Jones | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
Version: | MySQL 4.1.8-nt | OS: | Windows (XP) |
Assigned to: | CPU Architecture: | Any |
[2 Jan 2005 14:51]
Paul Jones
[2 Jan 2005 16:17]
MySQL Verification Team
I did a fresh install and not found the table mysql.user_info: "Tables_in_mysql" "columns_priv" "db" "func" "help_category" "help_keyword" "help_relation" "help_topic" "host" "tables_priv" "time_zone" "time_zone_leap_second" "time_zone_name" "time_zone_transition" "time_zone_transition_type" "user" Anyway could you please show the result of: show create table user_info Thanks in advance.
[6 Jan 2005 23:20]
Michael G. Zinner
This table is created my the MySQL Administrator. Could you state which version of the MySQL Administrator you are using? The user_info table should be created using a UTF8 charset.
[7 Jan 2005 8:20]
Paul Jones
Hi Mike That makes sense - it's 1.0.18 Paul
[7 Jan 2005 8:24]
Paul Jones
Hi Miguel - sorry for the delay 'user_info', 'CREATE TABLE `user_info` ( `User` varchar(16) NOT NULL default '', `Full_name` varchar(60) default NULL, `Description` varchar(255) default NULL, `Email` varchar(80) default NULL, `Contact_information` text, `Icon` blob, PRIMARY KEY (`User`), KEY `user_info_Full_name` (`Full_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores additional user information''
[14 Jan 2005 15:47]
MySQL Verification Team
Paul, can you try MySQL Administrator 1.0.19? user_info has utf8 character set for me.
[16 Jan 2005 12:29]
Paul Jones
Hi Victoria I tried the latest 1.0.19 but still get new tables created in latin1_swedish_ci using Administrator
[17 Feb 2005 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[17 Feb 2005 10:13]
Paul Jones
Hi - still no resolution
[17 Feb 2005 16:26]
MySQL Verification Team
I still can't reproduce it. What character set settings for the MySQL server do you use?
[18 Mar 2005 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".