Marvin Cummings wrote:
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 s
Marvin Cummings wrote:
Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads:
(
`ad_id` smallint(5) unsigned NOT NULL auto_inc
Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads:
(
`ad_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` sma
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 intent
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' to
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 myod
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 stu
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 t
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 pla
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
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
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 @mycom
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 di
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 acco
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 slave.
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). I
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 connec
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 e
18 matches
Mail list logo
