Auto_Increment Value
Hi all, I have a simple table with an Auto_Increment column. I insert NULL to this column each time I insert a row to have an automatic unique value. The problem is that I want to have new automatically generated value back to insert it to another table. How can I have new Auto_Increment value back at the same time I send NULL to it and it is gerenated ? Regards, Danesh
Auto_Increment value
Hi all, I have a simple table with an Auto_Increment column. I insert NULL to this column each time I insert a row to have an automatic unique value. The problem is that I want to have new automatically generated value back to insert it to another table. How can I have new Auto_Increment value back at the same time I send NULL to it and it is gerenated ? Regards, Danesh
Upgrading from 3.23 to 4.1
Hi all, I have installed FC3 on a system which supposed to act as Database server on a small LAN. MySQL server version 3.23 (I think) and all its parts has been installed. How can I upgrade it to MySQL 4.1 (latest version). Can anyone guide me step by step ? Here is some critical information on server and it is almost hard to reformat it. Thanks, Danesh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP and MySQL
Hi all, I have installed MySQL Server 4.1.7 on a Linux Fedora Core 3 machine. It works great locally and remotely. This machine also supposed to act as a web server by using Apache 2.0.52 and it works fine too. Apache is enhanced with PHP and they works together perfect. The only problem is with using MySQL through PHP. I think PHP should automatically use its built-in functions to manipulate MySQL databases, isn't it ? When I run this little PHP script I always get fail error message: /[EMAIL PROTECTED](localhost, root, myrootpass); if (!$link_id) { echo Failed !; exit; } */ Should I change something in php.ini ? Thanks, Danesh Daroui
MySQL and PHP
Hi all, I have problem by using PHP and MySQL. I have installed MySQL Server 4.1.7 on a Linux machine with Apache. PHP interpreter has been installed on it by default but I am not sure if PHP modules for MySQL has been installed too or not. On MySQL download section there is only some extensions which has links to PHP site. I couldn't use them really. Can anybody help ? How can I install PHP modules for MySQL so I would work with mysql database through PHP ? Regards, Danesh
MySQL configuring on Linux
Hi all, I have installed MySQL Server 4.1.7 on both my Windows XP and Linux Fedore Core 3 systems. It was amazing that everything can be configured in a visual way and it is almost ready to use after installation when install it on Windows XP and I could even change the way thatI want to use MySQL server if it is Developing, Sever or Dedicated Server. But when I installed MySQL Server 4.1.7 on my Linux system, I couldn't configure it as Windows XP. It just installed and there was not any configuration window or anything elase. How can I configure my Linux server for example to act as Dedicated server ? Is there any extra program for Linux so I have to download ? Thanks, Danesh Daroui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Remote user problem
Hi all, I have am in trouble with connecting remotely to my MySQL Server Linux machine. I have installed the latest RPM (4.1.7) on a Linux Fedora Core 3 machine. I have created root account and everything seems to be OK. The only problem is that I can not connect to my MySQL Server remotely from my Windows machine. I could do that before I upgrade from 4.1.5 to 4.1.7 on Fedora Core 2. In fact I can connect locally on my Linux machine as below: /* mysql -u root -p*/ but when I use this command I get the following error: /* mysql -h 127.0.0.1 -u root -p Error 1045 (28000): Access denied for user 'root'@'localhost.localdomain'. (using password YES) */ and as a result I can not from my Windows machine either. Whats wrong ? Can anybody help ? By the way, I could connect locally on my windows machine by using both above commands. Regards, Danesh Daroui
Remote Connecting
Hi all, I have a Linux Fedora Core 3 machine which is supposed to act as database server and a Windows XP client. I had installed mysql server 4.1.5 before and I have defined remote user on my Linux machine as below: GRANT ALL PRIVILEGES ON *.* TO 'RemoteUser'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; and I could connect to my server from my Windows XP client like below: mysql -h 192.168.1.2 -u RemoteUser -p and everything was OK. Now, I have upgraded my both server and client to MySQL 4.1.7 which is the latest version and now I can not connect to my server as before. Can anyone help ? Is there something which has been changed in new version ? Thanks, Danesh Daroui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Still problem with MyODBC :((
Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui
ODBC problem
Hi all, I have a Linux Database Server which runs MySQL 4.1 and a Windows Client machine which runs MySQL 4.1 too. I have installed the latest version of MyODBC on both machines and they have been installed successfully. Now, at the Administrative Tools in the Control Panel on my Windows system (Client) when I try to connect to my Linux system by using a valid user it doesn't connect and returns an error message which is: [MySQL][ODBC 3.51 Driver] Client does not supportauthentication protocol requested by server; consider upgrade MySQL client. What is the problem ? What should I do now ? I am totaly confuse, please help... Regards, Danesh Daroui
Remote Connecting
Hi all, I have installed Mysql-4.1 successfully on a Fedora Core 2 Linux system. Now, I like to connect to my Linux system from my other system which as Windows XP and of course Mysql 4.1 installed too. In fact, I like to connect to my Linux system as root and do all console tasks just like I am working with my Linux system. I tried to do that like below on my Windows XP system: mysql -u [EMAIL PROTECTED] -p but it was failed. How can I do this ? Please help me. Regards, Danesh Daroui
Installing MySQL 4.1 from RPM on Fedora2
Hi all, I have installed Server, Client, Benhcmark, Share, Embeded and Compact-Share RPMs version 4.1 on a Fedora2 system. The have been installed successfully but when I type: Shell mysql -u root it says that it can not open socket and I think it is because mysqld is not alive. When I type: Shell mysqld it returns a fatal error and refers me to Security notes about installation. Also, I thought that an user account which name is mysql should be created automatically when RPMs are installed, but there is no user account with name mysql !!! Please help me to fix the problem and install mysql on my linux system. Regards, Danesh Daroui