MYSQL :: Issues With 3.23.56 And 4.0.13 Using Mysqld

Server Load Issues
Im not sure if this is the right section since the problem is probably a combination of mysql/apache config issues.Firstly, the server is running FreeBSD and is a dual xeon with 1.5GB RAM and 4GB swap. The loads are around 3 most the time but spike to 6-7 every few minutes. mysqladmin status shows 500 queries a second (the site gets a few hundred hits a second).Ive tried searching for some optimal configs but google didnt turn many up, most the queries are selects but some of them have fairly complicated joins (5-6 joins in same query).Everything which is used in order by, where or in a join is indexed and some of the tables which have temp data have already been setup as heaps.

View Replies !

MySQL Server Startup Issues
For some reason I cannot get my MySQL server to start. It has been
running fine until Friday, when we has a strange issue with the
Solaris server which it is running on. The server had a few files get
their chmod setting messed up and now after fixing that, MySQL won't
start.

Exerpt from neuro18.err:

040830 15:55:19 mysqld started
040830 15:55:19 Can't start server : UNIX Socket : Permission denied
040830 15:55:19 Aborting

040830 15:55:19 /usr/local/mysql-standard-4.0.20-sun-solaris2.8-sparc/bin/mysqld:
Shutdown Complete

040830 15:55:19 mysqld ended

ps -ef|grep mysql yeilds no other mysqk processes running.

ls -l in /usr/local/mysql yeilds:

-rw-r--r-- 1 root mysql 19106 May 13 20:14 COPYING
-rw-r--r-- 1 root mysql 8403 May 13 20:14 INSTALL-BINARY
-rw-r--r-- 1 root mysql 1937 May 13 19:53 README
drwxr-xr-x 2 root mysql 1536 May 13 21:59 bin
-rwxr-xr-x 1 root mysql 773 May 13 21:59 configure
drwxrwxr-x 9 mysql mysql 512 Aug 30 15:55 data
drwxr-xr-x 2 root mysql 512 May 13 21:59 docs
drwxr-xr-x 2 root mysql 1536 May 13 21:59 include
drwxr-xr-x 2 root mysql 512 May 13 21:59 lib
drwxr-xr-x 3 root mysql 512 May 13 21:59 man
drwxr-xr-x 6 root mysql 512 May 13 21:59 mysql-test
drwxr-xr-x 2 root mysql 512 May 13 21:59 scripts
drwxr-xr-x 3 root mysql 512 May 13 21:59 share
drwxr-xr-x 5 root mysql 1024 May 13 21:59 sql-bench
drwxr-xr-x 2 root mysql 512 May 13 21:59 support-files
drwxr-xr-x 2 root mysql 512 May 13 21:59 tests...

View Replies !

Mysqld_multi Don't Starts Groups On Linux RedHat 9
mysqld_multi doesn't start the two groups if I gave this command imediately after stopping them.

View Replies !

Issues With IF()
Has anyone noticed issues with IF() or IF(expr1, CONCAT(exp1, exp2), CONCAT(exp1, exp2)) after upgrading from MySQL 4.0 to 4.1? A query in our system seems to be hanging and eating up some serious CPU usage (around 99%), yet on 4.0, the system seems to breeze through this query.

View Replies !

Log In Issues
I just started my MySql account from my Yahoo Small Business Webhosting account. I'm confused now, becuase I installed the PhpAdmin tool that they told me to, but now I can't sign into it. The PhpAdmin site says this is a MySql issue. It appears that my username and password aren't correct.

I am positive that I'm giving the username and password that I created when I created my MySql database a few minutes ago. I keep getting this error message: #1045 - Access denied for user 'root'@'localhost' (using password: YES). I tried resetting my password (to the same password that I gave when I started the account and also tried setting it to an entirely new one). The Yahoo help files said: "If your PHP or Perl configuration files require a host name, you may have a problem with your host name. Make sure that you are using the host name mysql, not the default host name localhost." I'm confused as to what username I should be typing, in this case.

View Replies !

Collation Issues
by default, my collation is set to latin1_swedish_ci, which I think is normal, but how do I switch that to normal English, or utf8 and keep that there as the default?

View Replies !

Grant Issues
The scenario is as following:

1. I have a database with 240 tables.
2. I can access all these tables on local host
3. I can access only 5 tables from another remote IP/client.
4. Only one of these tables is listed in "information_schema", look at following query: .....

View Replies !

Innodb Issues
I've inherited a database server that is bad shape. The database is very slow to spite having ample hardware. Symptoms:

1. From the mysql user agent the tables (innodb) work as normal although, slowely.

2. Looking at the file system, the files that store the table data are not being updated. Instead a very large files called ibdata1 is being updated regularly.

We think that the innodb engine in this version of mysql (4.0.18) is in some kind of unstable situation. What do you think? What do you recommend we do to fix this?

View Replies !

Mysql_connect() Issues
My database was working fine until I set a password. I used
"set password" from the mysql> and now I can only connect to mysql from the command prompt. My connection string is like so: $link=mysql_connect("localhost","root","xxxxxxx");
I get the error:
"Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES)"

When I connect from the prompt I do:
mysql db_name -p
then is asks for the password. Once I enter that I'm good to go.
If I completely omit the password from my mysql_connect statement, then it will connect.
Does anyone know what is going on?

View Replies !

Mysql & Xp Issues
I'm not exactly a novice to computing or developing but I am a total novice with mySQL and anything that stems from it and after a trying several tutorials out and searching the forums, I am still stumped. SO any help would be appreciated.I am trying to install a 4.1 release of win32 mySQL and am having major problems getting a server to run at all. (it doesn't have to be 4.1)I get as far as installing it and then an auto configurator pops up and tries to set it up and then fails miserably.

I need this for OpenCMS (OpenCMS.org). Any advice welcome. Though if that advice is to remove xp or dual boot I need to look at other options.

View Replies !

Utf8 Issues
I am making a full system backup to make sure if one computer goes down the other will be up and nothing will happen, but when I try to put the phpMyAdmin database on the backup it gives me this error

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8 COLLATE utf8_bin' at line 1

this is the only line I put in to focus on the problem, but I do not know what it is
CREATE DATABASE `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

View Replies !

BigINT Issues..?
I have a PHP script which adds money to a user's bank, the bank feild uses bigInt with a length of 40. bigINT(40).

However, if the bank of a user surpasses 1trillion (1,000,000,000,000) then it resets to 0. I thought bigINT supported far larger numbers? Why is it happening??

View Replies !

MySQL Issues
I have a few issues related to MySQL. Here are they:

1. As MySQL is acquired by Sun it is not clear how much effort Sun will provide to develop MySQL.

2. The cost might change after the acquisition from Sun which might affect the popularity of MySQL.

3. MySQL might not be suitable for large organisation.

4. Absence of stored procedures, sub-selects and triggers. (Check)

5. Failure to meet the ACID test - it is perfect though for storing/tracking non-critical data. (Check)

Does MySQL 5 corrects these issues? How many of these are sorted in the latest version?

View Replies !

Speed Issues
I have 15,000,000 bank records that are querried against 60,000 census records.

There is a primary index on the census table(concatonation of state/msa and tract) that corresponds to an index on the bank table(not unique on the bank table). I need these indexs to perform timely INNER JOIN querries.

NOTE - all querries that I describe are make temporary tables. They have to be for my app - unless there is an alternate way similar to make tables that I can use. Maybe w/ views?

The proscess works if I filter the bank table down to the state and county levels. If I just filter at the state level the querries drag - Illinois can be 5-10 minutes. I tried to add indexs on the STATE in both the bank and census table but it didn't seem to affect the peformance.

Is Mysql not made to handle 10s of millions of records? Is 10 minutes not long on this query? Am I properly indexing?

If I remove the census table from the equation and just do a straight WHERE things still slog at a slow pace

View Replies !

4.1.14 Upgrade Issues
I had 4.0 running on my local machine but my ISP upgraded to 4.1.14 so I had to as well.

However, the upgrade didn't go as smoothly for me... I removed the service - before I realized I didn't have to. I then installed 4.1.14 without issue But now I can't get the new service to start.

View Replies !

MySQL 5 Issues
I upgraded from 4.1 to 5.0 just to see if there where any changes that would break my application. After a lot of troubleshooting trying to track down the issue I was able to pin it down.I am using php 5 and a MySQL based session layer. After successfull login the login script redirects the user to the members area.
It seems the INSERT used to save the user information for the session is not being completed before the members page loads so the login fails.
I can fix this by doing 2 diffrent things
1. Backing down to MySQL 4.1 and everything works
2. Pausing the script for 1 sec prior to forwarding ( therefore giving mysql time to update ) works as well.

View Replies !

Memory Issues
We have recently installed beta version of our application on IBM - Pentium Xeon - dual processor, 1 GB RAM, 80 GB HDD on Fedora Core 3 OS. The kernel version which I currently have is: 2.6.9-1.667 and Mysql Server version: 4.0.20-standard.

I have noticed that mysql processes (using 'top' command) take up substantial amount of memory over period of time. Please take a look at mysql processes output of 'top' command below: Code:

View Replies !

Joining Issues
I av a table "code_desc" with the columns: code, desc. an example of a row from it is 01, Industrial Designs respectively.
I have another table with the name q_lists with a column referencing from the code_desc table in something similar to this:

select q.id, cd.desc from q_lists as q, code_desc as cd where q.department=cd.code
//department colums in the q_list table contains int values
//which are fully represented with original values in the code_desc table.
//this saves space

Lately i found the need of adding 1 more column (ministry) to the q_list table referencing from code_desc just the same way as the department column

The problem now is how to retrieve the real values of both from the code_desc table in the same query such that i av something something like:

id | department | ministry
---+------------------+---------
24 | Industrial Designs | Education

View Replies !

Match Against Issues
I have a query that is searching a fulltext field in the database using match against. I get 0 returns, however i believe this might be caused by the keyword being in to many rows and is being ignored by default in mysql. I've posted the query in case i am wrong. However if i'm not wrong how would i create a fulltext search? ....

View Replies !

SQL Query Issues
**********QUESTION CHANGED*****************
Error

SQL query: Documentation

SELECT sum( subtotal ) AS total_count
FROM (

SELECT 'male' AS source, id, thumbnail, name, height, chest, waist, collar, NULL , shoe, eyes, race, hair
FROM male_models
WHERE concat( id, thumbnail, name, height, chest, waist, collar, shoe, eyes, race, hair ) LIKE '%a%'
UNION ALL SELECT 'female' AS source, id, thumbnail, name, height, bust, waist, dress, hips, shoe, eyes, race, hair
FROM female_models
WHERE concat( id, thumbnail, name, height, bust, waist, dress, hips, shoe, eyes, race, hair ) LIKE '%a%'
UNION ALL SELECT 'talent' AS source, id, thumbnail, name, NULL , NULL , NULL , NULL , NULL , NULL , NULL , race, NULL
FROM character_models
WHERE concat( id, thumbnail, name, race ) LIKE '%a%'
)

MySQL said: Documentation
#1248 - Every derived table must have its own alias

View Replies !

ISP Issues With INNODB
Am sort of in a fix at the moment. Am at the stage of creating my database from my ER diagram of which certain tables rely on the InnoDB storage engine for referential integrity, transactions etc. But shockingly enough my ISP doesnt offer InnoDB table types due to the overhead caused from transaction tables.

What can i do? Change hosts? Revisit my ER diagram and make them all MyISAM? - this means i have to manually maintain integrity across related tables - seems more of a nightmare to me.

I need comments on what to do. Thanks and looking forward to feedbacks.

View Replies !

Case Sensative Issues?
I notice that on unix the default for case sensative is off which means
tables created with upper case need to be referenced in sql as upper
case. It seems that if the case sensative variable is set to 1, then
select emp works as well as select EMP. Is there any reason not to set
it to 1? Also, is there an ansi standard for this?

View Replies !

Query Cache Issues
I have a MySQL server running 4.0.12 on a 12 CPU Sun U4500 with 12GB of
memory.
With the query cache running, this machine would noticeably "hiccup"
(just stop responding to requests) every so often and wouldn't squeeze
more then 1000 queries per second or so as a result (heavily mixed OLTP
work, with a lot of SELECT's and almost as many UPDATE's).
Without the Query Cache (and no other tweaking), I'm now at over 2100
at the same time of day.
Is there a problem with the query cache that causes MySQL to be far
less scalable then just straight MySQL/InnoDB?

Are there any thoughts on this? Is there a resource specifically for
high performance/high load MySQL implementation/usage?

View Replies !

Mysql Licensing Issues
for an internal LAN setup in our company, would i still need a license for it?

View Replies !

Database Connection Issues
ok here is the problem code
Code:

$db = mysql_connect("localhost", "grav1com_z3r0gr4", "****") or die("Could not connect.");
if(!$db)
die("no db");
if(!mysql_select_db("grav1com_bloghost",$db))
die("No database selected.");

ok when i try to use this script to connect to the database i get no databse selected which is infering that there is no database info in the mysql_select_db variable correct? then what is going on here? is there a slight error that i'm not seeing?

View Replies !

Date Formating Issues
I have a field in my database which is of type Date (YYYY-MM-DD) that I need to format using PHP.What I need to do is the following:

- Add 1 year to this date
- Compare thisdate with another date in same format to see if it has passed the date it is being compared with.
- Also if possible format this date into more easillyreadable format (e.g DD/MM/YY)
I have been through several sites and the Date() PHPmanual, but can't seem to find any answers.

View Replies !

Innodb, And Replication Issues
Im complety new to mysql and have the following questions about it :

1) what is innodb and innodb tables ? ( I know it enables the Db to be transactional but thats about it)
2) what are the advantages of using innodb tables ?
3) Are there any issues with Innodb tables and replication ?
4) and is replication widly used in mysql -is it stable or are there any pitfalls that could be avoided ?
5) how can i tell if a database is using innodb tables ?

View Replies !

DB User/password Issues
I've looked on google and searched through these forum pages for issues similar to mine only to find no answer to people who have posed a similar question so I'm hoping I catch someone who can help me with this one.
My MySQL will only allow me to connect to my DBs through the web if and only if my user password is set to blank. When using MySQL Administrator, I can have my root password set and log into that just fine but when I try to use root -> pw in say my phpmyadmin script, I get access denied errors. BUT, when i change my root password to blank (testing purposes only), the page loads just fine.
The same results occur when i create a test user, the test username can only connect if the password is blank. If one is set, I get those access denied errors.

View Replies !

Password / Connection Issues
I'm a first time user, installed 5.0 on my XP laptop. I could never get the database to connect (error 10061). When I open the CLI for password and enter it, it closes with a beep immediately. I looked on the doc and completely disabled my firewall. Didn't make a difference. I de-installed 5.0 and installed 4.1 instead. Same result. I did see a message that after re-installing, previous config and password may still apply.

Anyone faced the same issue on Windows XP SP2?
How can I completely reset / erase any configuration on the system and restart from scratch?

View Replies !

Delete Perfomance Issues
Does MySQL use available Indexes to perform Deletion of Multiple Rows or does it do a Table Trawl, Table Size 1.9 Million Records with 3 Indexes. I am trying to justify using MySQL instead of MSSQL for our main Database and MySQL is loosing out big time against MSSQL in my enviroment.

View Replies !

XAMPP Issues: MySQL
i am having trouble setting up my server. I have the latest XAMPP running on a windows98 machine. I have just installed it and I have to admit I am a total new-b at this but i managed to find the Apache configuration file and configure a few things like the listen port because my ISP blocks the default 80 for incoming, i configured the document root and also i saw this and did not know if it was important but i still configured it:

# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
#
ServerName XX.XX.XX.XX:PORT#

ofcourse the X's being my IP address and port number at the end. So im wondering is this the name that you use to connect to MySQL ? if so with or without the port number? once again i am a total new-b to this, I have no idea. I am however currently reading "PHP and MySQL for Dummies", lol. and it has this test script i guess to check if MySQL is up and running: Code:

View Replies !

Character Set Issues In Database
I'm quite new to MySQL and have been thrown in at the deep-end to produce a website for my employers (http://www.octane-magazine.com). It uses a MySQL database to store news stories, cars for sale, events etc.

I'm about to migrate to a dedicated server with root access.

The problem is that the data that I've transfered over from the old server doesn't seem to display correctly on the new server (with question marks for characters like quotes and pound signs etc).

This will almost certainly be a character set issue - but the problem is how to get around it?

The html on the old server is flagged as ISO-8859-1 (Latin1)

If anyone could take a look at both of them:

the old server webpage is http://www.octane-magazine.com
the new server webpage is http://octane.fqdn.net

View Replies !

Character Encoding Issues
The database version installed on the server is MYSQL 3.23.43-nt.
it seems sql queries such as "SET NAMES utf8;" and "SET CHARACTER SET utf8;" do not work on this version :-(

View Replies !

Mysql Too Many Connections Performance Issues
I have a website running on a linux/apache/mysql/php
server. I receive about 8,000-10,000 visitors a day with about 200,000
to 300,000 page views. The server is a RedHat Linux server running PHP
5.x, MySQL 5.x, Apache 2.x

We have been suffering from a number of performance issues. Our
hosting company has set our max connections to 100, and we are using
persistent connections in PHP. At times the mysqld process takes 100%
of the CPU. We have also been suffering from
mysql_pconnect(): Too many connections errors. What can I do to fix
these issues?

When I run a top on the server I see this ...
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5567 mysql 16 0 169m 42m 4236 S 81.2 4.2 3078:09 mysqld
32539 apache 15 0 42676 25m 7708 S 1.0 2.5 0:03.40 httpd
32572 apache 15 0 42680 25m 7708 S 1.0 2.5 0:02.98 httpd
32608 apache 15 0 42680 25m 7704 S 1.0 2.5 0:00.72 httpd
32542 apache 15 0 42704 25m 7712 S 0.7 2.5 0:03.38 httpd
32561 apache 15 0 42732 25m 7712 S 0.7 2.5 0:02.61 httpd
32567 apache 15 0 42680 25m 7708 S 0.7 2.5 0:02.60 httpd
32591 apache ...................................................

View Replies !

MySQL Command Issues With An ADO Recordset
I know you will probably say that I should use MS SQL Server DBs with ASP,
but my MySQL and ASP combo works and is affordable for me and up until now
didn't give me any grief until recently.

In essence, the following MySQL query commands cause my ASP to generate a
Type Mismatch error when I try to response.write the result of the query
fields:

Query 1

CONCAT(PICFILEWIDTH,' x ',PICFILEHEIGHT)

I call this query result into a dynamically-created array from a recordset
object, ie arrSQLData (the array) = oRSv.GetRows() (the recordset object),
but when I call say arrSQLData(0,0) it generates the type mismatch.

This used to work fine in the MySQL v4 something that had the crappy
installer, but since they made the new installer (and some other mods) it
causes this problem.

I've checked the MySQL site and it says that the above, which is an int, ' x
', another int is fine, but something in ASP doesn't like the result it
sends back.

Done a straight query from SQLyog and that displays it OK.

Query 2

IFNULL((sp.RRPTAX/sp.RRPNET),'0.00')

same again this generates a type mismatch when it used to work fine.
Obviously the command puts in 0.00 if the tax and net values are null, but
this doesn't work now. It generates a type mismatch.

Has anybody had this problem and fixed it?

View Replies !

4.0.14 Standard Creating User Issues
We just installed mysql 4.0.14 on an xserve. When trying to add users via
mascon I'm finding an issue I have not seen in previously releases. When
adding a user it seems that the new column ssl_cipher is a required field.

I know this is new for v4 but is it supposed to be a required field? What
should the default be? I can't modify any user without being notified that
it is required.

View Replies !

Delete And Speed / Safety Issues
I'm in the process of writing a Perl script to delete records out of a
database when the records are more than 90 days old. I'm running MySQL
version 4.0.12-standard. The db consists of around 620 MyISAM tables with
the following structure:

CREATE TABLE `ifInErrors_2` (
`id` int(11) NOT NULL default '0',
`dtime` datetime NOT NULL default '0000-00-00 00:00:00',
`counter` bigint(20) NOT NULL default '0',
KEY `ifInErrors_2_idx` (`dtime`)
) TYPE=MyISAM;

The tables range in size from 1-2 rows upwards to over 9,200,000 with an
average of around 570,000 rows. Updates to this database run constantly (it
records information from a program that monitors the routers and switches on
my company's WAN) at a rate of around 2600 inserts/minute.

I had originally planned to use syntax similar to:

DELETE * FROM table_name WHERE `dtime` < [90 days ago]

After the DELETE runs, I plan on running MYISAMCHK on the affected table.
Then I'll repeat both steps for all of the other tables in turn.

Does anyone have any suggestions for alternatives or is there anything I'm
missing here? I'm new to this stuff and may be way off base here. If so,
please tell me.

One last thing. I'm running out of Drive space and am I/O bound - I'm
writing this script in case I can't get the RAID array I'm hoping for.
Because of the I/O problem, execution time can sometimes be a factor in what
I do. Execution speed is a primary concern. If this takes a day or two to
run but the application can be running at the same time then there's no
problem. But if I have to shut down my application for any appreciable
length I time, then I have to find another way of doing this.

View Replies !

Replication :: Issues With LongBlob Datatype
Has anyone ever had any issues with the LongBlob datatype and replication.

I'm using 4.1.14

I got it working perfectly, it did thousands of queries and then when I did a show slave status. the sql thread was running but the I/O thread was not. I got the log_position and it's a longblob, microsoft word doc. huge binary string. I tried to stop slave; the skip_position = 1 thing, then start slave, but the I/O still wouldn't start up? I'm not sure how to get it back going or fix the longblob problem. I got no errors on the slave, the I/O is just dead, seemingly irreversable.

View Replies !

FULLTEXT Case Sensitive Issues
I am unable to get case-insensitive search results.

Everything I read tells me case-insensitive is the default...but...

I've tried several collations with no good results. Everything is case sensitve.

View Replies !

C Development On OSX: Library Load Issues
I have code that has been working on OSX [not Intel] for at least two years. We now have an Intel Mac and I am trying to recompile and debug the code for it. I am NOT a Mac expert. The older versions just did whit I hoped they would.

I have had two issues so far. I have been able to "fix" one:

The following GCC command "works" but the resulting binary can not be debugged.

gcc -Wall -ggdb -I/usr/local/mysql/include -o myProgram myProgram.c -L/usr/local/mysql/lib -lmysqlclient -lz

GCC says that there are no debugging objects in the executable and that it is "Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found)."

I found a web page that talked about adding "-framework CoreServices" to the compile line. That has allowed me to see the debugging info/set breakpoints, etc in my code but there is still a MySQL issue.

GDB reports:

warning: Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found).

This is interesting in that if you look at the compile line I say "-L/usr/local/mysql/lib -lmysqlclient" but gdb is trying to find "/usr/local/mysql/lib/mysql/libmysqlclient". GDB seems to be adding an extra "mysql" dir in the "-L' path.

View Replies !

Not Null Field Causing Issues
I have a C# application that calls a MySQL procedure and writes data to the db. All of the fields get populated properly but for the ID field, which is my PK field. It populates the field with an empty string instead of the value. the ID field is a varchar field.

When I try a direct insert through the MySql Query Browser, it populates the field correctly, but when using the C# code/appl. the above issue occurs.

View Replies !

Default Current Timestamp Issues
Using MySQL 4.1.7. I have a sole TIMESTAMP column in the table:

insert_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

Looking at the timestamp docs, a query with NULL or empty, should cause the column to use the current time for its default value, but is not automatically updated.

However, putting NULL or simply leaving blank in an INSERT query, gives 01/01/0001.
Any ideas?

View Replies !

W2K Shutdown Issues After MySQL 5 Install
Has anyone heard of MySQL5 causing W2K to have problems shutting down? I'm running a 2K Server with MySQL 5.0.16 and noticed that after the install, the server would not shutdown cleanly. If I disable the MySQL Server prior to shutdown, the server shuts down or restarts without a problem.

View Replies !

Installation & 'access Denied' Issues
Firstly, I tried to install MySQL 5, and ended up with the error: "Cannot create Windows service for MySql. Error: 0". So, I unistalled it, and downloaded MySQL 4.1, but came across the same problem.

I tried something that was suggested, and downloaded 4.0, and it installed fine, but when I try to switch databases I get the error: "Access denied for user '@localhost'".

I've seen both problems mentioned before, but none of the solutions provided worked, or I didn't understand how to perform them.

View Replies !

Order Issues With Int Column Type
I have a table with a primary int column type auto_increment. I then have a script that relies on the int column within the table to have the inserted rows in the correct order.

The problem is, all of the inserted rows will get the auto_increment id and it will be fine for awhile, and then random rows will begin to be out of order number wise.

It is key for the script to have all of the inserted rows in order, but for some reason MySQL keeps messing it up.

So I have to consistently perform the query:
ALTER TABLE `table1` ORDER BY `postid`

The query works, but I'm not always on when the table starts to mess up so it is very inconvenient to have to do this over and over again.

By the way I'm running version 5.0.27-standard-log.

View Replies !

PHP Catalogue: Displaying Data Issues
I had to try and create a series catalogue script. Basically, each series listed has a category it is sorted into, various tidbits of data on it, a description and a genre it is sorted into. To sort each series into one or more genres, I did the same as I did to sort it into categories, thus the genre is basically a category. What I want to do is display the tidbits of data, the description and the genres on one page. Code:

View Replies !

Issues With 3.23.56 And 4.0.13 Using Mysqld_multi On One Server