RE: Unable to connect to mysql with phpmyadmin

I've tried it both ways using the default root and no password and root with my assigned password. Either way returns an error. Here's a part of my config.inc.php file: // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can disable a server config

Can't connect (error 2003) to mysql 5.0 on other server

Hi, I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting mycompA$mysql -h mycompB -u mysql -p on host A, I can connect and to the mysql-server on host B. However when I start mycompB$mysql -h mycompA -u mysql -p on host B, I get the error message: ERROR 2003: Can't connect

compiling mysql and mysql crashing

I had to install a source version of mysql and one of the install docs strongly suggests using CXXFLAGS=03 -felide-constructors -fno-exceptions -fno-rtti because of some instances of mysql crashing. When I did that I noticed in the compile a line that said it wasn't supported by gcc (3.3.3). Im

Replication error

Hi, I'm trying to do a replication of two servers (one is mysql version 4.1.0-alpha-debug-debug (slave) on debian and the other is 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for now. What I've done is that I stopped the master, copied the data folder to the

Re: Deleting records using the 'LIMIT' clause

Harald Fuchs wrote: In article [EMAIL PROTECTED], Ross Honniball [EMAIL PROTECTED] writes: Hi all, I have positively identified the row I want to delete using: 'SELECT * FROM table LIMIT 10,1' No, you didn't. Since you did not include an ORDER BY clause, MySQL has returned the tenth row

Re: Unable to connect to mysql with phpmyadmin

Marvin Cummings wrote: I've tried it both ways using the default root and no password and root with my assigned password. Either way returns an error. Here's a part of my config.inc.php file: // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can

Re: Can't connect (error 2003) to mysql 5.0 on other server

I assume you have already verified that the mysql server is actually running on server A. Have you verified that server A is accepting tcp connections? Try running mysql -h mycompA -u mysql -p from server A. If it lets you in, try SELECT CURRENT_USER(); just to make sure it says

Re: Can't connect (error 2003) to mysql 5.0 on other server

Bingo!! With the installation of the 5.0 (I assume) skip-networking was set by default in /etc/mysql/my.cnf. That was it. Thanks. Mike I assume you have already verified that the mysql server is actually running on server A. Have you verified that server A is accepting tcp connections? Try

Complete confusion

Where is the best tutorial that will show me opening coding and possible other coding to get info out of the database, etc. I guess you might say a real newbie tutorial. Thanks dawson

Re: Complete confusion

Dawson, When you say coding do you mean programming or are you talking about SQL that you can run from the command line? You *can* create tables, load them, query them, etc. from the command line with just the MySQL/sql statements without having to know how to do programming. However, if you plan

Re: Complete confusion

Hi Rhino, What I was referring to was the mySQL statements. I'm working on redoing the form so there is no problem there, it is how to use the statements to code what needs to be done. I know everybody has to begin somewhere when they're learning how to do this I'm just looking for the best

Re: Complete confusion

If your looking for just sql tutorials check out http://www.geekgirls.com/menu_databases.htm which is tutorials for the basics of database and databases design or go here http://www.sqlcourse.com/ for a tutorial on basic SQL or here http://sqlcourse2.com/ for a look at some of the more advances

I need support

I can only connect to mysql with the username root and no password I have the ini file configured with a username and password but I can't connect with them. I am using win xp and winmysqladmin ver. 1.4 I cant genarate a report because it says I must be connected first. On the environment tab

RE: Unable to connect to mysql with phpmyadmin

I finally managed to get this working. It turns out I was using the wrong password for the root account and once I remembered what the correct password was I was able to log in via phpMyAdmin. I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6. Now I want to switch the 'auth_type'

mysqld crash, got following

InnoDB: Error: record field 3 len 4294967207 Heap no too big 5888 93 Error in page 117145 in index PRIMARY Record has 654 fields, should have 24 InnoDB: record RECORD: info bits 0 0: 040405 8:36:56 InnoDB: Assertion failure in thread 9226 in file ../include/page0page.ic line 482 InnoDB: We