 | | | MySQL on Win32 | | hi All
When I try to change root user-password from the shell using ANY of
the methods described in the reference manual it says that the USERS
table is read-only. My root password is blank and itHello I 'm having problems setting up users on mysql. I created a
database named db1 going to dos prompt and starting mysql > then give
it the command mysql -u root -p db1 < it then request the pHi!
I have a big problem I run MySQL 3.23.58 on a Windows Server 2003
about 2 years from now with no problem. But nowadays the service stops
without any reason. In system event log
"mysql service tI 'm trying to enable InnoDB support in my 5.0 database. I don 't have a mysql-max-nt executable and that 's what MySQL Administrator is trying to use. How do I turn on?
Thanks
MelissaI 'm wanting to use a PRINT statement to output variables in my stored procedure.... Like in MS SQL Server. How can I do this in MySQL? I just want to verify my processing.
Thanks
Melissa
Hi Fellows
I posted already a message in the General forum but didn 't get any response
yet.
That 's why try to get an answer on this channel.
We would like to access mySQL from CrystalReports aI 'm importing data into MySQL from a CVS file.... one column has dollar amounts. There are negative numbers like this... (999.99). Is there a way to get the database to convert this into.... -999.99We have done a complete rewrite of the Connector/ODBC docs - making this
one of the best chapters in the MySQL Reference Manual
- http //dev.mysql.com/doc/refman/5.1/en/myodbc-connector.html
Some oHello
I have been long a MS SQL server user but I want to
learn something from MySQL and PHP. So I tried to
install PHP and MySQL to my box (Windows 2000 NT
server).
However I couldn?t configur
ok I had to re-install had saved orig zip from when first downloaded
(mysql-4.1.9-win32.zip) intallation went ok but have two problems
1) can open console client only from DOS shell if I run Hi everyone!
We have an InnoDB database with its respective ibdata file. As you probably
know the ibdata has a fixed initial size and may grow as more data is
stored in the database. Curiously w
I 've been using MySQL server (4.1) on my W2k machine for over a year
w/no problems connect from Tomcat and from Java stand-alone classes..
but the other day installed XAMPP (for PHP development cHas anyone increase the MySQL memory allocation passed the 2GB Windows limitation? Did you need to change any variables within the MySQL executable? I 'm trying to find a good article with solid infoHello
I have been using MySQL version 4.0 because I have experienced problems since version 4.1 and later versions...
I tried to update to version 5.0 but problems remain in short....
Due to my sHi
Today our mysqld process is in hung mode. I 'm able to connect to mysqld
thru mysql client but none of the commands are going thru.
I tried 'show processlist ' and 'select 1 ' from mysql clientHi All
Have a problem I think MySQL has not built the use DB correctly. (built new
system so had to reinstall). phpMyadmin will connect if no password and
user is named in config file but MySQLDoes anyone know any info on the future of MySQL and InnoDB.... with Oracle buying InnoDB? Does MySQL have ideas on a different transactional db?Hi
Is there any command available to get all the table schema in a
particular database?
For e.g.
If I have database called TESTDB and say it has tables table1 table2
.. table10.
Instead Hi people
I need a little help...
i have 3 ip address in my server and i want to bind mysql only to 2 of them does the bind-address parameter in my.cnf suport that?
i 've tried some ways but nothinI am also having this problem. I am running Win/XP with Service Pack 1 on a 1.7 machine with 512 of RAM and a 20 GB hard drive. I took all of the defaults (basically I just pressed the enter key)
Hello everyone
Anyone has an idea where i can find an application that shows mysql
statistics and refreshes maybe once every second on the linux console?
stuff like connected users server load quthe following script produces an error
error no. 1005
can 't create table ...
MySQL version 5.0
MySQL Query Browser version 1.1.2
DROP TABLE IF EXISTS `hr`.`area`
CREATE TABLE `hr`.`area` (
Hi
Im currently making a small database wrapper in c++ using the mysql c api on
windows (using visual studio 2005). I 'm using mysql 5.0 and according to
http //dev.mysql.com/doc/refman/5.0/en/window
From <afarias@(protected) >
To win32@(protected)
Subject [Access Violation]
Description
<Getting MySql Administrator Exception "Access Violation at address 00981514 in
module libmysqladI 've got a table Effort
DROP TABLE IF EXISTS `projecttracking`.`effort`
CREATE TABLE `projecttracking`.`effort` (
`x500` varchar(10) NOT NULL default ' '
`projectID` tinyint(3) unsigned NOT NULVersions
Win2K v5.0 (Build 2195 SP4)
MySQL v4.1.12a-nt
MySQL Administrator v1.1.9
I have setup a scheduled backup task thru the Backup tab of MySQL Administrator but the task never executes at thHi
I need information on Copying to tmp table status.
Explain for some of our query shows 'Using temporary Using Filesort '.
When query goes into this state it takes very long time.
Need Hi
I have a merged table with 35 million records the below query takes
around 40 mins to return.
mysql > explain select distinct userid from mfs
+----+-------------+-------+-------+-------Hi
I need a help in optimizing a query. The explain of the query shows
using temporary and file sort. Is there a way to avoid it?
| fs |CREATE TABLE `fs` (
`id` bigint(20) NOT NULL defaHi
I have a performance issue I need help in fixing it.
I have a query which takes considerable amount of time during this time
any update on the table involved in the query gets locked.
S |
|
|
