How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Access to Stored Procedure Solved

I figured out a problem I was having, and just wanted to pass the solution along to anyone who may run into the same problem in the future. I've got a new problem now, but I'll deal with that in a separate message (if necessary). I was getting the error, #42000SELECT command denied to user

Function Does Not Exist

I'm using the following code in my ASP.NET application to add a new record to the database, and return the added ID: Cmd=New MySqlCommand(sp_InsertNewCamper,Conn) Cmd.CommandType = CommandType.StoredProcedure paramReqID = Cmd.Parameters.Add(return,SqlDbType.Int) paramReqID.Direction =

Command Denied on Stored Procedure

I'm trying to execute a MySQL Stored Procedure from my ASP.NET page: Cmd=New MySqlCommand(sp_InsertNewCamper,Conn) Cmd.CommandType = CommandType.StoredProcedure paramReqID = Cmd.Parameters.Add(return,SqlDbType.Int) paramReqID.Direction = ParameterDirection.ReturnValue

Format for saving date field.

When doing an update or insert into a database with a date field, the format for the data on the screen is m/d/. However, I believe that MySQL is expecting it in the format of -mm-dd. I'm using MySQL in an ASP.Net application. Is there an EASY way to convert to the data to a format that

Does BLOB=Memo?

I'm a bit new to MySQL. I need to create a Memo field (a field that could contain a lot of information). I know that in some languages, BLOB is a Memo field. Is that the case with MySQL? If so, are there some parameters that I need to use here, or should I use another type to represent my Memo

MySQL .NET Connector

I'm using the MySQL .Net connector to access my MySQL database from my ASP.Net application. I've got kind of a catch 22 thing going on here. I'm getting an error, which indicates that I need to set the debug=true in my web.config file (I realize this isn't a MySQL problem, but bare with me...).

Stored Procedure Question

I've got a stored procedure I'm trying to convert from MS SQL. I've gotton so far with it, but it's complaining about the INSERT command. It's a very simple stored procedure, so it should easy to figure out, but I'm not familiar with the MySQL Stored Procedure syntax. If someone can point out

rename database

How can I rename a database in MySQL 5? I've tried renaming he folder, and that just causes other problems. Some one sent me a stored procedure to try, but it will not execute. There are probably several places that need to be changed, but I don't know where those are. Could someone point me

How to rename a database

I need to rename a database. I read somewhere that I could simply stop the MySQL database server and rename the folder that contains the data, re-start MySQL, and I'm good-to-go. However, I tried this, and while it appears to have worked initially, when I try to access one of the tables in the

Stored Procedure Conversion

I am converting a MS SQL Server ASP application over to use MySQL. I have two simple stored procedures that I need to convert. I have very little experience with MS SQL stored procedures, and none-what-so-ever with stored procedures in MySQL, so I really don't know what this should look like. I'll

SQL Statement Conversion

I'm converting an application from SQL Server to MySQL. I have the following query that I need to convert: SELECT A.*, CO = CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END FROM Activities a ORDER BY Activity What is the proper syntax for this in MySQL? Thanks, Jesse -- MySQL