Re: Interfaces to 5.0.0

[Lokesh]

Gordon wrote:

A few weeks ago I download the windows version for 5.0.0 and installed
it on my machine. After successfully installing the new version I was
able to connect with all of my old tools including MyCC 0.9.3,
MySQLFront, SQLyog, cmd and MySQL Administrator. 

Yesterday I downloaded the 5.0.0 RPM's for linux and only cmd and the
9.0.4 version of MyCC. 

Is the interface different on the linux verion vs the windows version?
Is there some setting I can use to allow the old {and current MySQL
Administrator} to connect?

If you have upgraded from MySQL-3.x or MySQL 4.0; you surely need to 
concern about compatibility issues. Because of change in authentication 
mechanism, old clients (pre-4.1) can't talk to MySQL-5.0.0 servers.

Refer to http://www.mysql.com/doc/en/Upgrade.html, which lists the tasks 
and how to plan for upgrade

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Quick mysql question

[Lokesh]

[EMAIL PROTECTED] wrote:

Hi,

A quick question, which is the most stable version of mysql to run on a very busy and commercial website(s)?

4.0 or is 4.1 stable enough?

Thanks,
-R.A

4.0 is a released and stable version.
4.1 is a developement version which is alpha, but quite stable :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Downgrade Mysql from 4 to 3.23

[Lokesh]

Prasad wrote:

Hi,
I am developing a database in mysql 4.Is it possible to downgrade the same
into mysql 3.23.If its possible then how?


Refer to http://www.mysql.com/doc/en/Upgrade.html. It talks about both 
upgrade and downgrade

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem in setting Table Level Privileges

[Lokesh]

Udbhav Shah wrote:

Hi Everybody
Commands:

mysql -uroot
mysql> grant select,insert,update,delete on
try.TBL_MACIP to 'tryAdmin1'@'localhost';
mysql -utryAdmin1
mysql> use try
mysql> select * from TBL_MACIP;
/etc/init.d/mysql restrat
mysql -utryAdmin1
mysql>use try
ERROR 1044 (42000): Access denied for user:
''@'localhost' to database 'try'
mysql>show grants for 'tryAdmin1'@'localhost';
No privilege is set.
Using 
Server version  4.1.1-alpha-standard
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
OS  i686 GNU/Linux (RH9)

Used RPM to upgrade from 3.23 to 4.1.1

Should I send this problem as BUG?
Any Suggestion/HELP!!!
Thanks in Advance.

with regards
Udbhav Shah
B.E (Computer Engg)
Ahmedabad,Gujarat
India
=

Thinking is the Assets

Enterprise is the Way

Hard Work is the Solution

  - Ignited Minds 

 



__
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
Refer to http://www.mysql.com/doc/en/Upgrade.html. There are quite a few 
tasks you need to perform to upgrade, like changing privilege tables. 
The above link gives the steps that need to be performed for upgrading 
to a later version

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and ROLES

[Lokesh]

Bram Mariën wrote:
Hey
 
I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it
in the past), and I must say, I'm really really impressed about the speed,
and the easy of administrating the server and it's data!
 
But, as I've looked through the documentation, I miss the prescence of
'ROLE' in MySQL  Is it true, that at this point, there's no 'ROLE'-support
in MYSQL, or did I just overlook it in the large documentation?
 
Kindest regards, 
 
 
Bram

It is not supported

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]