[Opensim-users] MySQL Errors Unique to Linux and .net

[Kyle Hamilton]

I must point out that it's not at all recommended to run any service
using the root user (it's literally akin to running things
authenticated as 'sa' under Oracle).

That said, if it works with the root user, then it's not an OpenSim
problem, it's a MySQL permission-configuration problem.  (Which, from
the original message, is what that error message indicates anyway.)

-Kyle H

On Wed, Feb 27, 2008 at 2:51 PM, ken yasue <ken at grid-pion.com> wrote:
> I had same problem in OpenSim0.5.0 release in LinuxBox.
>  I just changed to connect mysql by root user, and it worked.
>  So try connect with root user... If you can :)
>
>  Ken Yasue
>
>
>
>  Terry Ford wrote:
>  > Hi all,
>  >
>  > I'm new to the list but look forward to participating often.
>  > I have been able to compile/run .5 on my XP machine using mysql and it
>  > works well.
>  >
>  > I decided to try to run it from my linux machine using mysql but
>  > everytime I try starting the user server or the main opensim.exe file I
>  > keep rec'ing the following error:
>  >
>  > Unhandled Exception: MySql.Data.MySqlClient.MySqlException: SELECT
>  > command denied to user: 'username at localhost' for table 'TABLES'
>  >   at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
>  >   at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64&
>  > affectedRows, System.Int64& lastInsertId) [0x00000]
>  >   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000]
>  >   at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
>  >
>  > I've have done some research on my own and have found this to be a linux
>  > specific problem when using c#.
>  >
>  > Has anyone figured out a workaround??
>  >
>  > Thanks,
>  > -Terry
>  >
>  > _______________________________________________
>  > Opensim-users mailing list
>  > Opensim-users at lists.berlios.de
>  > https://lists.berlios.de/mailman/listinfo/opensim-users
>  >
>  >
>
>  _______________________________________________
>  Opensim-users mailing list
>  Opensim-users at lists.berlios.de
>  https://lists.berlios.de/mailman/listinfo/opensim-users
>