MySQL sorts Norwegian/Scandinavian Characters wrong

2003-10-01 Thread Håkon Nilsen \(Exinet AS\)
Hi, When I try to sort the alphabet, the three characters only used for the norwegian language, Æ, Ø and Å, are sorted wrong. They should be sorted in the order ÆØÅ, but they're sorted ÅÆØ. I read some place that I could change the character-set to danish, and that that would solve the issue (as

Re: Access denied

2003-09-23 Thread Håkon Nilsen \(Exinet AS\)
Hi, You should do this: $connection=mysql_connect(host, username, password); And then when querying: $result=mysql_db_query(database, select * from table); From your error message it seems that your database is called simply 'database', and that the username is empty. This doesn't work. You

MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
Hi, All my MySQL users have access to all databases and all tables, allthough I've only given them access to one. How can I correct this? Is it possible to have them *only* see their database when i.e. typing 'show databases;', and also refuse them connection to any database but their own?

Re: MySQL user privileges

2003-09-22 Thread Håkon Nilsen \(Exinet AS\)
Thank you, Egor, I *had* the anonymous user, but I deleted it since I couldn't find the use for it. But I figured out what the problem was. I was using --safe-show-database, but it didn't seem to work. My error was that I gave users privileges. I also gave the privileges to the user on the