Re: [newbie] MySQL File Location
SOTL wrote: Well I change the datadir in mysql-max and I have generated numerous versions of my.cnf directing MySQL to my desired directory each change causing MySQL refused to run. So I keep playing around with mysql-max and found that there is a second place where the config file does a test of the datadir so I changed that. At that point MySQL would open and did switch data directories. Continued to play with MySQL, making and deleting DB et. i.e. all the things a newbie does with a book and a new program. Then, I shut the box down for the night and went home. It is after all only a test box at this time but it is damn noise so to keep the piece down it goes. Anyway, firing it up the next afternoon I was amassed to discover that MySQL would not open with the same old error message that it could not find the data directory. I the reset the data directory to the original settings and MySQL again started working. So, there are at least 3 places that you MUST change the data directory at in configuration files in order to change the data directory. Best best is to do it by symbolic link as no newbie is going to figure out how to do it in configuration files. My only comment: How quaint, how 1950s that there exist programs in which one can not select the data directory. Frank PS. Thanks for the help. It is definitely appreciated. Frank, One thing to keep in mind, when changing things in the file in /etc/rc.d/init.d - You have to stop and restart MySQL before they take effect. The values in the script are only read at startup. You should probably learn about the service command. If you are using mysql, then you would run service mysql start to start it, service mysql stop to stop it, and service mysql restart to test your changes. If you use mysql-max, then use that in mlace of mysql in the service command. You may also be having a problem because on not understanding how the script works. Not every instruction in the script get run. It does tests, and if a value is set, then it skips part of the code. This is why you see references to /etc/my.cnf in the script, even though creating or changing this file has no affect on MySQL. This is because that part of the script does not get accessed on a Mandrake box. So you will want to be carefull aboout changing things in the script. The values that you would want to change are always at the beginning of the line, and normaly have a comment block before them. Mikkel -- Do not meddle in the affairs of dragons, for you are crunchy and taste good with Ketchup! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
SOTL wrote: del Hi All Derek and Mikkel Thanks for the information. Derek sorry I did not mean to be insulting. I simply do not understand and am very happy for your help which I thank you very much for. I have checked I do not have a file called S90MySQL in any location. I especially checked that it does NOT exist at /etc/rc5.d/S90mysql. Nor do I have a file /etc/rc.d/init.d/mysql. What I do have is a file /etc/rc.d/init.d/mysql-max. I had taken a look at this file earlier but dismissed it assuming that it is not the correct file. MySQL-Max was placed on both boxes at one point in time and the removed. On reinstallation of MySQL standard MySQL was installed not MySQL-Max. This may be the source of the configuration file issue. Currently both boxes have MySQL installed. I have printed the MySQL-Max file and it is a 4 1/2 pages #10 font program which I can read some of - not much since I am not a programmer. One interesting thing I did notice is that it refers to checking a configuration file called my.cnf which I do not have. As I know that I do not have the technical expertize to create a my.cnf file I would appreciate someone sending me a copy of a simple one that functions. Thanks Frank The mysql or mysql-max files are the scripts used to start mysql. There are a few config options in the file. The important one for your is the line: datadir=/var/lib/mysql If you want your mysql data someplace other then /var/lib/mysql, then you will need to chege this line. You will want to create a my.cnf file in this directory. It can be an empty file. The script fills in the missing entries with usable defaults. Mikkel -- Do not meddle in the affairs of dragons, for you are crunchy and taste good with Ketchup! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
del Hi All Derek and Mikkel Thanks for the information. Derek sorry I did not mean to be insulting. I simply do not understand and am very happy for your help which I thank you very much for. I have checked I do not have a file called S90MySQL in any location. I especially checked that it does NOT exist at /etc/rc5.d/S90mysql. Nor do I have a file /etc/rc.d/init.d/mysql. What I do have is a file /etc/rc.d/init.d/mysql-max. I had taken a look at this file earlier but dismissed it assuming that it is not the correct file. MySQL-Max was placed on both boxes at one point in time and the removed. On reinstallation of MySQL standard MySQL was installed not MySQL-Max. This may be the source of the configuration file issue. Currently both boxes have MySQL installed. I have printed the MySQL-Max file and it is a 4 1/2 pages #10 font program which I can read some of - not much since I am not a programmer. One interesting thing I did notice is that it refers to checking a configuration file called my.cnf which I do not have. As I know that I do not have the technical expertize to create a my.cnf file I would appreciate someone sending me a copy of a simple one that functions. Thanks Frank The packager who built the Mandrake package for MySQL has created the file /etc/rc5.d/S90mysql to set up the defaults for MySQL so that a my.cnf file is unnecessary. I simply read that file and told you what the defaults were set to. I also told you that by using a symlink to /var/lib/mysql you could put your user data in a different folder without having to edit any files or create a my.cnf file. BTW: A pid file is a file usually kept in /var/run which identifies the Process Identifier number (pid) a daemon is using derek Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
SOTL wrote: On Tuesday 15 March 2005 11:21, Derek Jennings wrote: On Tuesday 15 March 2005 14:42, SOTL wrote: Hi All I have created a partition on one of my computer to store critical system data files called /System_Data. I am trying to configure MySQL so that it will use /System_Data as its default file storage. I looked for /etc/my.cnf; found I did not have one so I generated one. My /etc/my.cnf files contains exactly 1 line which is: datadir=/System_Data When I start MySQL I now receive the following error message: Found option without preceding group in config file /etc/my.cnf at line 1. Fatail error in default handling. Program aborted. Would appreciate help in ascertaining what should be added or how current should be modified. Frank It is failing because having created a /etc/my.cnf file it is expecting to find other parameters defined in there in addition to datadir (pid_file=, basedir=/, bindir=/usr/bin ) You could alternatively edit the datadir path in /etc/rc5.d/S90mysql which is the script that starts mysql Alternatively if you create a symlink from /var/lib/mysql to /mnt/System_Data/mysql then you would not need to change any configuration and your data would go in the folder you desire. BTW: In Linux /var is the default directory to hold data so why do you need to define a different one? derek Hi All and thanks Derek I have finally gotten back to the above issue in my attempts to resolve my setup issues. I have printed the instructions for Using Option Files as kindly pointed out to me by David G Stevenson located at: http://dev.mysql.com/doc/mysql/en/option-files.html If I understand Derek correctly my.cnf should look something like [mysql] datadir=/System_Data basedir=/ bindir=/usr/bin pid_file= This raises two issues to me. First what is a 'pid_file=' ? And where is it located? Second I do not find pid_file, basedir, or bindir mentioned in the MySQL Reference Manual:: 4.3.2 Using Option Files. Thus to say the least I am confused. if someone would mind enlighten me on correct procedure I would appreciate it. Thank Frank You may want to take a look at /etc/rc.d/init.d/mysql to see were a lot of things are by default, and how they are set. If you leave pid_file= blank, it gets set in this file. The file gets created when mysql starts, and contains the Program ID (PID) of the MySQL server. Looking at this file, it looks like this is where you would set your data directory, and you would put my.cfg in the data directory you set in this file. Mikkel -- Do not meddle in the affairs of dragons, for you are crunchy and taste good with Ketchup! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
On Monday 21 March 2005 22:31, SOTL wrote: On Tuesday 15 March 2005 11:21, Derek Jennings wrote: On Tuesday 15 March 2005 14:42, SOTL wrote: Hi All I have created a partition on one of my computer to store critical system data files called /System_Data. I am trying to configure MySQL so that it will use /System_Data as its default file storage. I looked for /etc/my.cnf; found I did not have one so I generated one. My /etc/my.cnf files contains exactly 1 line which is: datadir=/System_Data When I start MySQL I now receive the following error message: Found option without preceding group in config file /etc/my.cnf at line 1. Fatail error in default handling. Program aborted. Would appreciate help in ascertaining what should be added or how current should be modified. Frank It is failing because having created a /etc/my.cnf file it is expecting to find other parameters defined in there in addition to datadir (pid_file=, basedir=/, bindir=/usr/bin ) You could alternatively edit the datadir path in /etc/rc5.d/S90mysql which is the script that starts mysql Alternatively if you create a symlink from /var/lib/mysql to /mnt/System_Data/mysql then you would not need to change any configuration and your data would go in the folder you desire. BTW: In Linux /var is the default directory to hold data so why do you need to define a different one? derek Hi All and thanks Derek I have finally gotten back to the above issue in my attempts to resolve my setup issues. I have printed the instructions for Using Option Files as kindly pointed out to me by David G Stevenson located at: http://dev.mysql.com/doc/mysql/en/option-files.html If I understand Derek correctly my.cnf should look something like [mysql] datadir=/System_Data basedir=/ bindir=/usr/bin pid_file= This raises two issues to me. First what is a 'pid_file=' ? And where is it located? Second I do not find pid_file, basedir, or bindir mentioned in the MySQL Reference Manual:: 4.3.2 Using Option Files. Thus to say the least I am confused. if someone would mind enlighten me on correct procedure I would appreciate it. Thank Frank The packager who built the Mandrake package for MySQL has created the file /etc/rc5.d/S90mysql to set up the defaults for MySQL so that a my.cnf file is unnecessary. I simply read that file and told you what the defaults were set to. I also told you that by using a symlink to /var/lib/mysql you could put your user data in a different folder without having to edit any files or create a my.cnf file. BTW: A pid file is a file usually kept in /var/run which identifies the Process Identifier number (pid) a daemon is using derek -- www.jennings.homelinux.net http://twiki.mdklinuxfaq.org Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
Derek Jennings wrote: The packager who built the Mandrake package for MySQL has created the file /etc/rc5.d/S90mysql to set up the defaults for MySQL so that a my.cnf file is unnecessary. I simply read that file and told you what the defaults were set to. I also told you that by using a symlink to /var/lib/mysql you could put your user data in a different folder without having to edit any files or create a my.cnf file. BTW: A pid file is a file usually kept in /var/run which identifies the Process Identifier number (pid) a daemon is using derek Minnor correction - the file is actualy /etc/rc.d/init.d/mysql. The files in /etc/rc.d/rc#.d are symlinks to the files in /etc/rc.d/init.d and are created/removed by chkconfig. The /etc/rc#.d entries are symlinks to the directories in /etc/rc.d. If you would like to know more about this, you may want to read /usr/share/doc/initscripts-7.61.1/sysvinitfiles. Mikkel -- Do not meddle in the affairs of dragons, for you are crunchy and taste good with Ketchup! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
[newbie] MySQL DB Connection to Open Office
Hi All Well I have ascertained that the principal reason that I am unable to connect to a DB using OO is that Java is not installed in OO. Java is installed on the computer but the OO-1.9 installation did not recognize this so now the first issue is how does one install Java into OO. Since there is a principal reason there must by necessity be as least one more reason which I am sorry to say is another installation issue of software into OO. It also appears that even though there are drivers for JDBC installed in OO-1.1 which is also installed on this box that OO-1.9 does not recognize these drivers existence so again the question is how does one go about installing these drivers into OO. The issue is not where to down load Java or the drivers or which Java and drivers are needed but in how to install both Java and the JDBC drivers. Would appreciate a little enlightnment of how one goes about making these installations. Thanks Frank Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
[newbie] MySQL File Location
Hi All I have created a partition on one of my computer to store critical system data files called /mnt/System_Data. I am trying to configure MySQL so that it will use /mnt/System_Data as its default file storage. I looked for /etc/my.cnf; found I did not have one so I generated one. My /etc/my.cnf files contains exactly 1 line which is: datadir=/mnt/System_Data When I start MySQL I now receive the following error message: Found option without preceding group in config file /etc/my.cnf at line 1. Fatail error in default handling. Program aborted. Would appreciate help in ascertaining what should be added or how current should be modified. Frank Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
On Tuesday 15 March 2005 14:42, SOTL wrote: Hi All I have created a partition on one of my computer to store critical system data files called /mnt/System_Data. I am trying to configure MySQL so that it will use /mnt/System_Data as its default file storage. I looked for /etc/my.cnf; found I did not have one so I generated one. My /etc/my.cnf files contains exactly 1 line which is: datadir=/mnt/System_Data When I start MySQL I now receive the following error message: Found option without preceding group in config file /etc/my.cnf at line 1. Fatail error in default handling. Program aborted. Would appreciate help in ascertaining what should be added or how current should be modified. Frank It is failing because having created a /etc/my.cnf file it is expecting to find other parameters defined in there in addition to datadir (pid_file=, basedir=/, bindir=/usr/bin ) You could alternatively edit the datadir path in /etc/rc5.d/S90mysql which is the script that starts mysql Alternatively if you create a symlink from /var/lib/mysql to /mnt/System_Data/mysql then you would not need to change any configuration and your data would go in the folder you desire. BTW: In Linux /var is the default directory to hold data so why do you need to define a different one? derek -- www.jennings.homelinux.net http://twiki.mdklinuxfaq.org Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL File Location
On Tuesday 15 March 2005 11:21, Derek Jennings wrote: On Tuesday 15 March 2005 14:42, SOTL wrote: Hi All I have created a partition on one of my computer to store critical system data files called /mnt/System_Data. I am trying to configure MySQL so that it will use /mnt/System_Data as its default file storage. I looked for /etc/my.cnf; found I did not have one so I generated one. My /etc/my.cnf files contains exactly 1 line which is: datadir=/mnt/System_Data When I start MySQL I now receive the following error message: Found option without preceding group in config file /etc/my.cnf at line 1. Fatail error in default handling. Program aborted. Would appreciate help in ascertaining what should be added or how current should be modified. Frank It is failing because having created a /etc/my.cnf file it is expecting to find other parameters defined in there in addition to datadir (pid_file=, basedir=/, bindir=/usr/bin ) You could alternatively edit the datadir path in /etc/rc5.d/S90mysql which is the script that starts mysql Alternatively if you create a symlink from /var/lib/mysql to /mnt/System_Data/mysql then you would not need to change any configuration and your data would go in the folder you desire. BTW: In Linux /var is the default directory to hold data so why do you need to define a different one? derek Well I changed the file to be [MYSQL] datadir=/mnt/System_Data and I got: Error unknown variable 'datadir=/mnt/System_Data' which I did not understand. So, I open another .cnf file and edited to be identical by changing name-X within the [name-X] to [MYSQL] and then editing a linewith datadir= /dir/dir/file-name to datadir=/mnt/System_Data The final product was: file = /etc/my.cnf with contents of [MYSQL] datadir=/mnt/System_Data Then I tested it and it worked. I would not bother people on this list with this but it is not the first time it has happened. That is I type a configuration file check it re check it and it refuse to function then copy and edit a file from some other location edit it to where it is exact and I do mean exact equal the the one I created from the keyboard and it function correctly. Does anyone have any explanation why creating a new file from keyboard refuses to work and editing and existing file and saving it works? Frank Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL
On Thursday 17 February 2005 15:04, David G Stevenson wrote:
Brant Fitzsimmons wrote:
SOTL wrote:
Hi All
As some of you are aware I started last week trying to make a data
base using MySQL.
I that light I have a nice book, some book examples, and questions
that are not answered in the book.
This computer is set up with all data located on a separate partition
called /home/trunk/Common_Data which allows both the Linux and MS OS
to see the data.. Yea I know strange location not using
/mnt/Common_Data/{file name or directory} but I like it that way.
Anyway I would like to place my data bases in the same location.
Currently when I create a db it is located in /var/lib/mysql/{file
name} so I preceded to copy one of the db I had made called testdb
to my desired location. Then I tried to access testdb or as the db
people say connect to testdb.
Anyway I tried the following
use /home/trunk/Common_Data/testdb
plus a few variations of this eachtime receiving the response that the
db which MC says exist does not exist.
Would some kind person please explain how one creates, connects, and
uses a db in any other directory except /var/lib/mysql/*.
Thanks
Frank
All of the following must be done as root.
Turn off your mysql server process:
*# service mysql stop
*Copy your databases to the new location:
*# cp -a /var/lib/mysql /home/trunk/Common_Data/
*Rename your current mysql directory to keep it safe until you know that
your changes are working properly:
*# mv /var/lib/mysql /var/lib/mysql_backup_20050217
*Create a symlink in /var/lib/ to the new location:
*# ln -s **/home/trunk/Common_Data/mysql /var/lib/mysql
*Restart the server:
*# service mysql start*
or,
stop mysql server,
edit /etc/my.cnf
change,
datadir=/var/lib/mysql
to
datadir=/home/trunk/Common_Data/
move the data to new location (including the system mysql database)
then restart mysql server
Thanks for the help
I just checked and my version of Mandrake 10.1 does not have a
file /etc/my.cnf
Is that correct or am I missing something in my installation? If so whit
should I do? Should I just generate the file with the above configuration
parameters in it? If so am I missing other configuration parameters?
Thanks
Frank
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL
SOTL wrote:
On Thursday 17 February 2005 15:04, David G Stevenson wrote:
Brant Fitzsimmons wrote:
SOTL wrote:
Hi All
As some of you are aware I started last week trying to make a data
base using MySQL.
I that light I have a nice book, some book examples, and questions
that are not answered in the book.
This computer is set up with all data located on a separate partition
called /home/trunk/Common_Data which allows both the Linux and MS OS
to see the data.. Yea I know strange location not using
/mnt/Common_Data/{file name or directory} but I like it that way.
Anyway I would like to place my data bases in the same location.
Currently when I create a db it is located in /var/lib/mysql/{file
name} so I preceded to copy one of the db I had made called testdb
to my desired location. Then I tried to access testdb or as the db
people say connect to testdb.
Anyway I tried the following
use /home/trunk/Common_Data/testdb
plus a few variations of this eachtime receiving the response that the
db which MC says exist does not exist.
Would some kind person please explain how one creates, connects, and
uses a db in any other directory except /var/lib/mysql/*.
Thanks
Frank
All of the following must be done as root.
Turn off your mysql server process:
*# service mysql stop
*Copy your databases to the new location:
*# cp -a /var/lib/mysql /home/trunk/Common_Data/
*Rename your current mysql directory to keep it safe until you know that
your changes are working properly:
*# mv /var/lib/mysql /var/lib/mysql_backup_20050217
*Create a symlink in /var/lib/ to the new location:
*# ln -s **/home/trunk/Common_Data/mysql /var/lib/mysql
*Restart the server:
*# service mysql start*
or,
stop mysql server,
edit /etc/my.cnf
change,
datadir=/var/lib/mysql
to
datadir=/home/trunk/Common_Data/
move the data to new location (including the system mysql database)
then restart mysql server
Thanks for the help
I just checked and my version of Mandrake 10.1 does not have a
file /etc/my.cnf
Is that correct or am I missing something in my installation? If so whit
should I do? Should I just generate the file with the above configuration
parameters in it? If so am I missing other configuration parameters?
Take a look at:
http://dev.mysql.com/doc/mysql/en/option-files.html
This will describe the my.cnf file at its available options. If the file
exist it will be read and override default mysql options.
For example, here is my file:
start example file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
end example file
On the server this came from it is pretty default.
HTH
--
Thanks,
David
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL
SOTL wrote:
Hi All
As some of you are aware I started last week trying to make a data base using
MySQL.
I that light I have a nice book, some book examples, and questions that are
not answered in the book.
This computer is set up with all data located on a separate partition
called /home/trunk/Common_Data which allows both the Linux and MS OS to see
the data.. Yea I know strange location not using /mnt/Common_Data/{file name
or directory} but I like it that way. Anyway I would like to place my data
bases in the same location.
Currently when I create a db it is located in /var/lib/mysql/{file name} so I
preceded to copy one of the db I had made called testdb to my desired
location. Then I tried to access testdb or as the db people say connect to
testdb.
Anyway I tried the following
use /home/trunk/Common_Data/testdb
plus a few variations of this eachtime receiving the response that the db
which MC says exist does not exist.
Would some kind person please explain how one creates, connects, and uses a db
in any other directory except /var/lib/mysql/*.
Thanks
Frank
All of the following must be done as root.
Turn off your mysql server process:
*# service mysql stop
*Copy your databases to the new location:
*# cp -a /var/lib/mysql /home/trunk/Common_Data/
*Rename your current mysql directory to keep it safe until you know that
your changes are working properly:
*# mv /var/lib/mysql /var/lib/mysql_backup_20050217
*Create a symlink in /var/lib/ to the new location:
*# ln -s **/home/trunk/Common_Data/mysql /var/lib/mysql
*Restart the server:
*# service mysql start*
--
Brant Fitzsimmons
[EMAIL PROTECTED]
---
Linux user #322847 | Linux machine #207465 | http://counter.li.org/
Mandrake 10.1 for i586, kernel 2.6.8.1-24mdk
14:20:00 up 17 days, 11:52, 1 user, load average: 1.08, 0.89, 0.67
---
Press on: nothing in the world can take the place of
perseverance. Talent will not; nothing is more common than
unsuccessful men with talent. Genius will not; unrewarded genius
is almost a proverb. Education will not; the world is full of
educated derelicts. Persistence and determination alone are
omnipotent.
-Calvin Coolidge
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL
Brant Fitzsimmons wrote:
SOTL wrote:
Hi All
As some of you are aware I started last week trying to make a data
base using MySQL.
I that light I have a nice book, some book examples, and questions
that are not answered in the book.
This computer is set up with all data located on a separate partition
called /home/trunk/Common_Data which allows both the Linux and MS OS
to see the data.. Yea I know strange location not using
/mnt/Common_Data/{file name or directory} but I like it that way.
Anyway I would like to place my data bases in the same location.
Currently when I create a db it is located in /var/lib/mysql/{file
name} so I preceded to copy one of the db I had made called testdb
to my desired location. Then I tried to access testdb or as the db
people say connect to testdb.
Anyway I tried the following
use /home/trunk/Common_Data/testdb
plus a few variations of this eachtime receiving the response that the
db which MC says exist does not exist.
Would some kind person please explain how one creates, connects, and
uses a db in any other directory except /var/lib/mysql/*.
Thanks
Frank
All of the following must be done as root.
Turn off your mysql server process:
*# service mysql stop
*Copy your databases to the new location:
*# cp -a /var/lib/mysql /home/trunk/Common_Data/
*Rename your current mysql directory to keep it safe until you know that
your changes are working properly:
*# mv /var/lib/mysql /var/lib/mysql_backup_20050217
*Create a symlink in /var/lib/ to the new location:
*# ln -s **/home/trunk/Common_Data/mysql /var/lib/mysql
*Restart the server:
*# service mysql start*
or,
stop mysql server,
edit /etc/my.cnf
change,
datadir=/var/lib/mysql
to
datadir=/home/trunk/Common_Data/
move the data to new location (including the system mysql database)
then restart mysql server
--
Thanks,
David
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
[newbie] MySQL
Hi All
As some of you are aware I started last week trying to make a data base using
MySQL.
I that light I have a nice book, some book examples, and questions that are
not answered in the book.
This computer is set up with all data located on a separate partition
called /home/trunk/Common_Data which allows both the Linux and MS OS to see
the data.. Yea I know strange location not using /mnt/Common_Data/{file name
or directory} but I like it that way. Anyway I would like to place my data
bases in the same location.
Currently when I create a db it is located in /var/lib/mysql/{file name} so I
preceded to copy one of the db I had made called testdb to my desired
location. Then I tried to access testdb or as the db people say connect to
testdb.
Anyway I tried the following
use /home/trunk/Common_Data/testdb
plus a few variations of this eachtime receiving the response that the db
which MC says exist does not exist.
Would some kind person please explain how one creates, connects, and uses a db
in any other directory except /var/lib/mysql/*.
Thanks
Frank
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
[newbie] MySQL WOn't Start
Dears, I can't run MySql it says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can you help Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL WOn't Start
Op Sat, 18 Dec 2004 23:30:21 +0300 schreef EE: Dears, I can't run MySql it says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Does the file /var/lib/mysql/mysql.sock exist? If not, then probably the MySQL daemon is not running. Paul -- The one thing that doesn't abide by majority rule is a person's conscience. -Harper Lee http://www.nlpagan.net/linux.php Have you visited http://twiki.mdklinuxfaq.org yet? Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL WOn't Start
On Saturday 18 December 2004 20:30, EE wrote: Dears, I can't run MySql it says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can you help What do you see in the syslog when you restart the mysql service? derek -- www.jennings.homelinux.net http://twiki.mdklinuxfaq.org Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
[newbie] MySQL 4.1 doesn't start in 9.2, 10.0 and 10.1
Hi: I've worked with MySQL 4.1 since the alpha release (4.1.0). I always download the latest rpms from mysql.com and install them with rpm. Until version 4.1.4 every thing was just fine. However, when I tried to install 4.1.5 rpms in my fully updated Mandrake 10.0, I got an error telling me that mysql didn't have permissions to access /root/tmp. MySQL was installed but couldn't be started. Humm, something wrong with this rpms. I post a message in the mysql list and they told me to give, temporarily, 777 access to /root/tmp to start the service, which I did. The service started but I couldn't work with the database after settings /root/tmp permissions back to the original ones (700). I went back to install 4.1.4, which I had working before, and I got the same error. My conclusion was that something was wrong with my box. I modified the mysql init script in /etc/init.d to start mysql as user root and the database started working nicely. After that I installed 4.1.5 which is now working without problem. However, running mysql as root is not considered a good security practice. Then, one of my coworker, who uses Mandrake 9.2, told me that he was facing the same problem with 4.1.5. After modifying mysql init script as I did the data base started to work. Then I decided to go to a different computer and installed 10.1 CE. The same problem with mysql. Again, modifying mysql init script solved the situation. Decided to go deeper into it, I installed mysql in a box running Debian 3.0r2 using the generic Linux installer. No problem whatsoever. Then I tried installing mysql in 10.0 using the same binary and I got the same problem. BTW, Debian has no /root/tmp at all. At this point, I believe that there is something in Mandrake causing the problem but I have no idea where to start looking at. Can I just remove /root/tmp and try to start mysql again? Has anybody in this list tried to install MySQL 4.1.4 or 4.1.5 in 9.2 or 10 fully updated or in 10.1 CE without update? Can some body give me a hint about where the problem might be? Any help would be highly appreciated. Adolfo Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL 4.1 doesn't start in 9.2, 10.0 and 10.1
On Fri, 8 Oct 2004, Adolfo Bello wrote: Hi: I've worked with MySQL 4.1 since the alpha release (4.1.0). I always download the latest rpms from mysql.com and install them with rpm. Until version 4.1.4 every thing was just fine. However, when I tried to install 4.1.5 rpms in my fully updated Mandrake 10.0, I got an error telling me that mysql didn't have permissions to access /root/tmp. MySQL was installed but couldn't be started. Humm, something wrong with this rpms. I post a message in the mysql list and they told me to give, temporarily, 777 access to /root/tmp to start the service, which I did. The service started but I couldn't work with the database after settings /root/tmp permissions back to the original ones (700). I went back to install 4.1.4, which I had working before, and I got the same error. My conclusion was that something was wrong with my box. I modified the mysql init script in /etc/init.d to start mysql as user root and the database started working nicely. After that I installed 4.1.5 which is now working without problem. However, running mysql as root is not considered a good security practice. Then, one of my coworker, who uses Mandrake 9.2, told me that he was facing the same problem with 4.1.5. After modifying mysql init script as I did the data base started to work. Then I decided to go to a different computer and installed 10.1 CE. The same problem with mysql. Again, modifying mysql init script solved the situation. Decided to go deeper into it, I installed mysql in a box running Debian 3.0r2 using the generic Linux installer. No problem whatsoever. Then I tried installing mysql in 10.0 using the same binary and I got the same problem. BTW, Debian has no /root/tmp at all. At this point, I believe that there is something in Mandrake causing the problem but I have no idea where to start looking at. Can I just remove /root/tmp and try to start mysql again? Has anybody in this list tried to install MySQL 4.1.4 or 4.1.5 in 9.2 or 10 fully updated or in 10.1 CE without update? Can some body give me a hint about where the problem might be? Sounds like the init script is picking up root's TMPDIR TMP variables. You might try unsetting these in the init script, rather than running MySQL as root. You'll note the mandrake package defines these vars in start: TMPDIR=/tmp export TMPDIR TMP=/tmp export TMP -- Stew Benedict Mandrakesoft --- [This E-mail scanned for viruses by Declude Virus] Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] MySQL 4.1 doesn't start in 9.2, 10.0 and 10.1
On Fri, 2004-10-08 at 11:00, Stew Benedict wrote: On Fri, 8 Oct 2004, Adolfo Bello wrote: Hi: I've worked with MySQL 4.1 since the alpha release (4.1.0). I always download the latest rpms from mysql.com and install them with rpm. Until version 4.1.4 every thing was just fine. However, when I tried to install 4.1.5 rpms in my fully updated Mandrake 10.0, I got an error telling me that mysql didn't have permissions to access /root/tmp. MySQL was installed but couldn't be started. Humm, something wrong with this rpms. I post a message in the mysql list and they told me to give, temporarily, 777 access to /root/tmp to start the service, which I did. The service started but I couldn't work with the database after settings /root/tmp permissions back to the original ones (700). I went back to install 4.1.4, which I had working before, and I got the same error. My conclusion was that something was wrong with my box. I modified the mysql init script in /etc/init.d to start mysql as user root and the database started working nicely. After that I installed 4.1.5 which is now working without problem. However, running mysql as root is not considered a good security practice. Then, one of my coworker, who uses Mandrake 9.2, told me that he was facing the same problem with 4.1.5. After modifying mysql init script as I did the data base started to work. Then I decided to go to a different computer and installed 10.1 CE. The same problem with mysql. Again, modifying mysql init script solved the situation. Decided to go deeper into it, I installed mysql in a box running Debian 3.0r2 using the generic Linux installer. No problem whatsoever. Then I tried installing mysql in 10.0 using the same binary and I got the same problem. BTW, Debian has no /root/tmp at all. At this point, I believe that there is something in Mandrake causing the problem but I have no idea where to start looking at. Can I just remove /root/tmp and try to start mysql again? Has anybody in this list tried to install MySQL 4.1.4 or 4.1.5 in 9.2 or 10 fully updated or in 10.1 CE without update? Can some body give me a hint about where the problem might be? Sounds like the init script is picking up root's TMPDIR TMP variables. You might try unsetting these in the init script, rather than running MySQL as root. You'll note the mandrake package defines these vars in start: TMPDIR=/tmp export TMPDIR TMP=/tmp export TMP That was it! It is working now as user mysql. Thanks a lot. Adolfo Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
[newbie] MySQL 4.1 for Mandrake?
Dear all, Does anyone have tried to install MySQL 4.1 in Mdk 9.2? I have downloaded the rpm from mysql.com, but it seems that I can't use the rpm -Uvh option. So, I removed the previous version and installed the new one. The installation process complained about some thread number, but it proceeded. After it, when I tried to run the mysql server, it just stayed there, nothing showed in the log. Is there MySQL 4.1 package available from Mandrake (particularly mdk9.2)? Thanks, Fajar. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
[newbie] MySQL not starting
Hi, I am trying to start MySQL using mysql start and get the following error message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Can anyone give me a clue as to how to get round this? -- Regards, David David Andersonmailto:[EMAIL PROTECTED] Using The Bat! v2.11 on Windows 2000 5.0 Build 2195 Service Pack 4 Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Join the Club : http://www.mandrakeclub.com
Re: [newbie] mysql
[root@rwideman2 root]# mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) It should ask you for a password here (note that it said using password: no). The only reason I know why it wouldn't do so is when you have somewhere defined to use an empty password. Have a look into ~/.my.cnf resp. /etc/my.cnf (if either exists) and look for a line like password= Nope. No files... Regardless, you can force the command to ask you for a password by adding -p: mysql -u root -p mysql WAHO, asked for password. WAHO I am in. [root@rwideman2 root]# mysql -u mysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' Of course, some arbitrary user is not allowed to access the database where the access rights are stored (named mysql). But at least, it let you login. Ye, i was thinkin the password just got totally corrupted then i couldnt do anything the link i had up had on it...nothing worked. [root@rwideman2 root]# mysql --user=mysql Welcome to the MySQL monitor. Commands end with ; or \g. Same as above, it let you login as user mysql, but you have no right to access the database mysql. This is my 2nd day (yesterday was my first) to mess with MySQLI am definitely on a learning curve with this. I tried the password editing options listed on http://www.mysql.com/doc/en/Access_denied.html and still cant fix it. That you have missed the part about --skip-grant-tables apparently? Nope, i tried it, nogo. That is to be expected. Removing MySQL will not remove any database (in order to protect you from data loss) and the access rights are stored in a database. So you are working on the same databases with the same privilege settings. I figured this but wasnt for sure. What do you mean by that? The database *files* should be under /var/lib/mysql. That you have some DB is obvious by the fact that you once managed to login (without any database, you would get something like could not find file 'host.frm as error). Meaning i did NOT create a DB or do ANYTHING except change the root password within MySQL. Its the learning curve kicking in... I tried to verify the files that were installed by: The commands and results you quoted already show that apparently MySQL is installed correctly. You just have problems to login for whatever reason. But see the suggestions above. Is there away to completely remove mysql files and start over? If you de-install MySQL (via rpm) and then also do /var/lib/mysql, /etc/my.cnf and ~/.my.cnf, you should got everything MySQL-related. MMM, will keep this in mind, but dont need it now. Thanks a biggy. Roba Newbie after 3 years. Once a Newbie, Always a Newbie, :) Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] mysql
I just installed 3.23.52 along with the requireds. I logged in and changed the password. Rebooted and now i cant login. [root@rwideman2 root]# mysql -u root mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@rwideman2 root]# mysql -u mysql mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' [root@rwideman2 root]# mysql --user=mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 3.23.52 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql I tried the password editing options listed on http://www.mysql.com/doc/en/Access_denied.html and still cant fix it. I removed mysql and installed it again and i am having the same issue. I have NO data, NO DB, nothing. I tried to verify the files that were installed by: [root@rwideman2 root]# rpm -V MySQL-3.23.52-1mdk .M.. c /etc/rc.d/init.d/mysql But i have no clue to what this means other than that is the service script. Is there away to completely remove mysql files and start over? Rob Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] MySQL-shared-3.23.52-1.i386.rpm installation error
To get OO work with MySQL, tried to install on MDK 9.0 ODBC drivers as instructed in the 'OO ODBC howto' doc but MySQL-shared-3.23.52-1.i386.rpm installation fails reporting conflict with libmysqlclient.so.10.0.0 libmysqlclient_r.so.10.0.0 How can I have a working OO ODBC/MySQL link? Spent the night w/o sleeping (and w/o solution) Regards... Bela Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL-shared-3.23.52-1.i386.rpm installation error
In reply to Márkus's mail, d.d. Tue, 04 Feb 2003 18:47:49 +0100: I got it to work by following this document: www.unixodbc.org/doc/OOoMySQL.pdf Good luck! Paul To get OO work with MySQL, tried to install on MDK 9.0 ODBC drivers as instructed in the 'OO ODBC howto' doc but MySQL-shared-3.23.52-1.i386.rpm installation fails reporting conflict with libmysqlclient.so.10.0.0 libmysqlclient_r.so.10.0.0 How can I have a working OO ODBC/MySQL link? Spent the night w/o sleeping (and w/o solution) Regards... Bela -- :1,$s/windows/linux/g http://nlpagan.net - Linux by Mandrake - Sylpheed by Hiro Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL-shared-3.23.52-1.i386.rpm installation error
On Tue, 2003-02-04 at 13:52, Paul wrote: In reply to Márkus's mail, d.d. Tue, 04 Feb 2003 18:47:49 +0100: I got it to work by following this document: www.unixodbc.org/doc/OOoMySQL.pdf Good luck! Paul Using MyODBC-3.51.05-1 and unixODBC-2.2.4, I had to create a symbolyc link with: ln -s /usr/lucal/lib/libodbc.so.1.0.0 /usr/lib/libodbc.so because OO looks for /usr/lib/libodbc.so and MyODBC uses usr/local/lib as the default install directory. OO ODBC-connections through queries are really slw. -- __ / \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED] / // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258 / \\ // / \\ / // // / //cel: +58 416 609-6213 /___// // / _/ \__\\ //__/ // fax: +58 212 952-6797 www.bisapi.com //pager: www.tun-tun.com (# 609-6213) Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
I know I didn't ask for the help, but I did want to say thank you Adolfo, you just resolved one of my many issues. I hope it works for you Benjamin. After a quick re-boot phpnuke was able to setup its database. :) Zane Minninger At 04:16 PM 1/31/2003, Adolfo Bello wrote: On Fri, 2003-01-31 at 16:16, Benjamin Jeeves wrote: Hi all For some reason mysql does not boot up on my system in the Control Center it is marked on boot but stopped can any one help on why Thank You Benjamin Jeeves I had the same problem overhere. Starting fine now after issuing the command: chkconfig --level 35 mysql on Drop the 5 if not using a graphical interphase. -- __ / \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED] / // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258 / \\ // / \\ / // // / //cel: +58 416 609-6213 /___// // / _/ \__\\ //__/ // fax: +58 212 952-6797 www.bisapi.com //pager: www.tun-tun.com (# 609-6213) Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] mysql
Hi all For some reason mysql does not boot up on my system in the Control Center it is marked on boot but stopped can any one help on why Thank You Benjamin Jeeves Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
On Fri, 2003-01-31 at 15:16, Benjamin Jeeves wrote: Hi all For some reason mysql does not boot up on my system in the Control Center it is marked on boot but stopped can any one help on why Thank You Benjamin Jeeves Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com This happened to me when I first installed 9.0 too. I just reset MySQL to start on boot using Webmin and it has started ever since. I also have the same problem with numlock--it's set to start on boot, but sometimes it does not. HTH, SW Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
On Fri, 2003-01-31 at 16:16, Benjamin Jeeves wrote: Hi all For some reason mysql does not boot up on my system in the Control Center it is marked on boot but stopped can any one help on why Thank You Benjamin Jeeves I had the same problem overhere. Starting fine now after issuing the command: chkconfig --level 35 mysql on Drop the 5 if not using a graphical interphase. -- __ / \\ @ __ __@ Adolfo Bello [EMAIL PROTECTED] / // // /\ / \\ // \ // Bello Ingenieria S.A, ICQ: 65910258 / \\ // / \\ / // // / //cel: +58 416 609-6213 /___// // / _/ \__\\ //__/ // fax: +58 212 952-6797 www.bisapi.com //pager: www.tun-tun.com (# 609-6213) Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL users DB corrupted
Hi. On Thu 2003-01-09 at 11:21:49 -0800, [EMAIL PROTECTED] wrote: I have a small problem where a power outage has corrupted the user database for mysql, now no users can authenticate/manipulate any databases hosted by the MySQL Engine... This is rather annoying since I am no longer able to administer the databases, and I appear to be unable to modify, or create users all together. The engine is running, and the availability of data is still there, but in a read only manner. I can pull data out, but unless I can authenticate, I cant enter any in! How can I fix this? Almost all of the admin tools I have found will not work without logging in. If there is no other solution, is it possible to import the existing database I have (used for inventory purposes) into a fresh mysql install? I cant export anything, and the database files are basically flat files at this point... A good web resource would also be appreciated! any help would be appreciated. There are several possibilities, some of them depend on how recent your version of MySQL is. - You can try repairing the tables from the shell with myisamchk (be sure to stop mysqld beforehand), like this: myisamchk -r /var/lib/mysql/mysql/*.MYI If there are no files ending in .MYI, but only .ISM, use the following instead: isamchk -r /var/lib/mysql/mysql/*.ISM Usually you would use REPAIR TABLES from the mysql prompt (or some graphic utility), but since you have problems authenticating I won't go into depth about that. The (my-)isamchk solution only requires that you have the file privileges (i.e. that you can become root). Make sure that the files belong to the same user as they did beforehand, when you are done. - Alternatively you can start MySQL so that ignores the privileges tables at all. *Note that running it this will is a security risk*, depending on your configuration and you should keep the time running MySQL this way short. Using --skip-networking reduces this risk, because only connection from the localhost are allowed then. You have to start MySQL with --skip-grant-tables (or short: -Sg). You can start it using safe_mysql: /usr/bin/safe_mysql --skip-grant-tables --skip-networking If that makes problems, you can alternatively edit the MySQL startup-script /etc/init.d/mysql (don't forget to change it back afterwards). When you connect to MySQL after starting it this way, you have all privileges the MySQL root usually has. You can try the mentioned REPAIR TABLES, if you want (it will do the same as myisamchk) or you can make a dump of your data - something like mysqldump --opt your_database somefile should do. Then remove all files in /var/lib/mysql and use /usr/bin/mysql_install_db to setup the privilege tables from scratch. Then play in your dump with something like mysqladmin create your_database mysql your_databaes somefile Well, I'll stop for now. Hope that gets you along. Bye, Benjamin. msg114910/pgp0.pgp Description: PGP signature
[newbie] MySQL users DB corrupted
I have a small problem where a power outage has corrupted the user database for mysql, now no users can authenticate/manipulate any databases hosted by the MySQL Engine... This is rather annoying since I am no longer able to administer the databases, and I appear to be unable to modify, or create users all together. The engine is running, and the availability of data is still there, but in a read only manner. I can pull data out, but unless I can authenticate, I cant enter any in! How can I fix this? Almost all of the admin tools I have found will not work without logging in. If there is no other solution, is it possible to import the existing database I have (used for inventory purposes) into a fresh mysql install? I cant export anything, and the database files are basically flat files at this point... A good web resource would also be appreciated! any help would be appreciated. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL users DB corrupted
On Fri, 2003-01-10 at 06:21, Cory wrote: I have a small problem where a power outage has corrupted the user database for mysql, now no users can authenticate/manipulate any databases hosted by the MySQL Engine... This is rather annoying since I am no longer able to administer the databases, and I appear to be unable to modify, or create users all together. The engine is running, and the availability of data is still there, but in a read only manner. I can pull data out, but unless I can authenticate, I cant enter any in! How can I fix this? Almost all of the admin tools I have found will not work without logging in. If there is no other solution, is it possible to import the existing database I have (used for inventory purposes) into a fresh mysql install? I cant export anything, and the database files are basically flat files at this point... A good web resource would also be appreciated! any help would be appreciated. Are you able to access the MySQL adminsitration applet through Webmin? Have you tried running /usr/bin/mysql_fix_privilege_tables ? -- Fri Jan 10 07:55:01 EST 2003 7:55am up 21:37, 5 users, load average: 0.60, 0.48, 0.39 -- |____ | kuhn media australia| | / ,, /| |'-. | http://kma.0catch.com | | .\__/ || | | |=| | _ / `._ \|_|_.-' | stephen kuhn| | | / \__.`=._) (_ | email: [EMAIL PROTECTED] | | |/ ._/ || | email: [EMAIL PROTECTED]| | |'. `\ | | |icq: 5483808 | | ;/ / | | | | | smk ) /_/| |.---.| | mobile: 0410-728-389| | ' `-`' | Berkeley, New South Wales, AU | -- * linux user:267497 * RH 7.3+ * PC/Mac/Linux/Networking/Consulting -- Nobody can be as agreeable as an uninvited guest. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL users DB corrupted
On TIf there is no other solution, is it possible to import the existing database I have (used for inventory purposes) into a fresh mysql install? I cant export anything, and the database files are basically flat files at this point... A good web resource would also be appreciated! any help would be appreciated. Have you tried mysqldump? Adolfo Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] MySQL
On Fri, 2002-11-22 at 21:23, Jordan Elver wrote: Hi, Can anyone tell me how to remove the MySQL rpms without KDE disapearing with it? When trying to remove, it also wants to remove the various KDE rpms? TIA, Jord -- Jordan Elver http://www.jordanelver.co.uk Press any key to continue or any other key to quit... Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com rpm -e --nodeps pkg But only, if you really want to do this! MfG Frank Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] MySQL
Hi, Can anyone tell me how to remove the MySQL rpms without KDE disapearing with it? When trying to remove, it also wants to remove the various KDE rpms? TIA, Jord -- Jordan Elver http://www.jordanelver.co.uk Press any key to continue or any other key to quit... Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] mysql deamon needs to be started by hand even though...
in the mandrake control center it is configured to start on boot. A pain to start the control center to start mysql. thanks in advance for any ideas. -- iggy Registered user 287116 at http://counter.li.org Registered computer 168591 at http://counter.li.org Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] MySQL
I went on a MySQL book hunt a while back and I've seen most of them, since I used to work in a MySQL shop. OReilly is OK, it's the easiest to get your hands on, but this one stood out from the rest qualitywise to me: MySQL by Paul DuBois New Riders Publishing ISBN # 0-7357-0921-1 Amazon used book listing for MySQL: http://www.amazon.com/exec/obidos/offering-page/ref=sdp_ab_ub/103-5215189-3195846?index=fixed-pricefield-offering-type=usedfield-asin=0735709211field-status=opensize=25rank=+price It has more about the MySQL C Api than any other book I've seen. Content is in depth and superb. HTH, LX Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] mysql
I need to learn mysql. I looked at bookpool and there are too many books to pick from. Can anyone give me a recommendation? I'm a C/Java programmer so it doesn't have to be too basic, just thorough and preferably not put me to sleep. Jeanie __ This is Linux country. On a quiet night, you can hear NT re-boot. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
On Friday 14 June 2002 6:36 pm, you wrote: On Fri, 14 Jun 2002, Schwenk, Jeanie wrote: I need to learn mysql. I looked at bookpool and there are too many books to pick from. Can anyone give me a recommendation? I found Sams Teach yourself Mysql in 21 days and O'Reilly's Mysql Msql both good and complemented each other. David Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
RE: [newbie] mysql
excellent book I bought is: MYSQL by Paul Dubois released by New Riders Its an excellent book covers SQL itself then mysql specifically, and covers most languages that can access it. perl, java, c, c++ etc etc... very well written, very easy to understand.. and it was edited by some of the guys that developed MySQL.. got my recommendation. rgds Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of daRcmaTTeR Sent: Saturday, 15 June 2002 1:36 AM To: '[EMAIL PROTECTED]' Subject: Re: [newbie] mysql On Fri, 14 Jun 2002, Schwenk, Jeanie wrote: I need to learn mysql. I looked at bookpool and there are too many books to pick from. Can anyone give me a recommendation? I'm a C/Java programmer so it doesn't have to be too basic, just thorough and preferably not put me to sleep. Jeanie Jeanie, take a look at what O'Reily has to offer. for my money their books are some of the best I've seen for alll types of programming. you can also get quite a bit of good information about MySQL from the Mysql documentation that comes with the packages. you can also view their docs online. http://www.mysql.com -- daRmaTTeR R L U: #186492 When ever people annoy me I remember, Vengence is mine saith the Lord. My prayer is, ...here am I Lord...send me! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
On Fri, 14 Jun 2002, Schwenk, Jeanie wrote: I need to learn mysql. I looked at bookpool and there are too many books to pick from. Can anyone give me a recommendation? I'm a C/Java programmer so it doesn't have to be too basic, just thorough and preferably not put me to sleep. Jeanie Jeanie, take a look at what O'Reily has to offer. for my money their books are some of the best I've seen for alll types of programming. you can also get quite a bit of good information about MySQL from the Mysql documentation that comes with the packages. you can also view their docs online. http://www.mysql.com -- daRmaTTeR R L U: #186492 When ever people annoy me I remember, Vengence is mine saith the Lord. My prayer is, ...here am I Lord...send me! Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] mysql
I learned how to get around in MySQL using the documentation at their site: mysql.com. Learn their material first, then you can spend yer money on a slightly more advanced book if you need to. Miark Schwenk, Jeanie [EMAIL PROTECTED] saith: I need to learn mysql. I looked at bookpool and there are too many books to pick from. Can anyone give me a recommendation? I'm a C/Java programmer so it doesn't have to be too basic, just thorough and preferably not put me to sleep. Jeanie __ This is Linux country. On a quiet night, you can hear NT re-boot. Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] MySQL book for Linux
Hi, I'm looking for BASIC MySQL book. Does anyone know which is the easy one? I want the book have some how show me the add-on (or plug-in) GUI.. I want to be able to create MySQL database like MA-Access or Paradox... I'm new at MySQL so just want buy a very easy book to read. Any help is a big thanks Tuan _ Do You Yahoo!? Get your free yahoo.com address at http://mail.yahoo.com Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
[newbie] MySql port?
Hi, all. I am looking to write some apps that will connect to a mysql database. I have the jdbc driver but I am not sure what port mysql is listening on. Can anyone help me find the port number? Thanks in advance, -Scott Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
Re: [newbie] Mysql! How do I set the root password from a base install?
On Thursday, Jun 07, 2001, h3rb wrote: I am gonna reply to you with a Quote from my first message: I can't add any database's or anything cause it tells me that root@localhost is denied access. Emphasize on the anything part! Did you even try what I suggested? -- [EMAIL PROTECTED], ICQ#: 25370820, OpenPGP key at www.keyserver.net 1024D/39F0BBF4 2024 B7CB 10BF 6BE7 2ECE E0FD 1360 0181 39F0 BBF4 Current Linux uptime: 7 days 19 hours 54 minutes.
RE: [newbie] Mysql! How do I set the root password from a base install?
http://www.mysql.com/doc/D/e/Default_privileges.html
shell mysql -u root mysql
mysql UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql FLUSH PRIVILEGES;
-Original Message-
From: h3rb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 1:00 AM
To: [EMAIL PROTECTED]
Subject: [newbie] Mysql! How do I set the root password from a base
install?
How do I set the root password for mysql? I can't add any
database's or
anything cause it tells me that root@localhost is denied
access. I switch to
the user mysql and try to change the password that way. And
mysql tell's me
that the user mysql doesn't have permission to change
passwords for other
users. Could anyone point me in the right direction? I have gone to
mysql.com and tried their solution to change a forgotton
password. And that
doesn't work either. I still can't connect to my database.
I have setup
mysql from scratch on other distro's. But this one with MDK8
is just about
driving me nutz.
h3rb
Re: [newbie] Mysql! How do I set the root password from a base install?
On Thursday, Jun 07, 2001, h3rb wrote: How do I set the root password for mysql? I can't add any database's or anything cause it tells me that root@localhost is denied access. I switch to the user mysql and try to change the password that way. And mysql tell's me that the user mysql doesn't have permission to change passwords for other users. Could anyone point me in the right direction? I have gone to mysql.com and tried their solution to change a forgotton password. And that doesn't work either. I still can't connect to my database. I have setup mysql from scratch on other distro's. But this one with MDK8 is just about driving me nutz. /usr/bin/mysqladmin -u root password 'whatever-password-you-want' should do it... -- [EMAIL PROTECTED], ICQ#: 25370820, OpenPGP key at www.keyserver.net 1024D/39F0BBF4 2024 B7CB 10BF 6BE7 2ECE E0FD 1360 0181 39F0 BBF4 Current Linux uptime: 6 days 13 hours 1 minutes.
Re: [newbie] Mysql! How do I set the root password from a base install?
I am gonna reply to you with a Quote from my first message: I can't add any database's or anything cause it tells me that root@localhost is denied access. Emphasize on the anything part! h3rb On Thursday 07 June 2001 10:54, Paul Cox wrote: On Thursday, Jun 07, 2001, h3rb wrote: How do I set the root password for mysql? I can't add any database's or anything cause it tells me that root@localhost is denied access. I switch to the user mysql and try to change the password that way. And mysql tell's me that the user mysql doesn't have permission to change passwords for other users. Could anyone point me in the right direction? I have gone to mysql.com and tried their solution to change a forgotton password. And that doesn't work either. I still can't connect to my database. I have setup mysql from scratch on other distro's. But this one with MDK8 is just about driving me nutz. /usr/bin/mysqladmin -u root password 'whatever-password-you-want' should do it...
[newbie] Mysql
Hi i have installed mysql and downloaded phpmyadmin(gui) it works fine, till i put my own db in /var/lib/mysql in phpmyadmin it lways give me the an error in a line that contains the following statement mysql_list_tables($db)! Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
[newbie] MySQL
I would like to know if someone can tell me how to setup and start up mysql, I've been reading the doc pages @mysql.com but they are kinda difficult and almost contain no info at all(well at least it doesn't apply to my case) so if anyone can help me with this matter I would really appreciate it. :-) by the way I'm using MD7.2 on a x686 mach. 10 gig HD 256MB RAM Thanks again!!! Julio
Re: [newbie] MySQL
get a source at www.mysql.com, usually it is a mysql-x.x.tar.gz 1. tar -zxvf mysql-x.x.tar.gz 2. cd mysql-x.x.x 3. ./configure 4. make 5. make install 6. scripts/mysql_install_db 7. cp support-files/mysql.server /etc/rc.d/init.d/mysql 8. chmod a+x /etcrc.d/init.d/mysql 9. setup 10. System services and check mysql the next time you restart your system mysql will run automatically or /usr/local/bin/safe_mysqld Hope this will help! On Mon, 19 Feb 2001, Julio Gutierrez wrote: I would like to know if someone can tell me how to setup and start up mysql, I've been reading the doc pages @mysql.com but they are kinda difficult and almost contain no info at all(well at least it doesn't apply to my case) so if anyone can help me with this matter I would really appreciate it. :-) by the way I'm using MD7.2 on a x686 mach. 10 gig HD 256MB RAM Thanks again!!! Julio -- - - - - - - - - - - - - - - a l l a n t. p a r r e n o OneVirtual Internet - Iloilo -- Make the first effort to work toward greatness. You will learn a lot as you go, and perfect your approach. The important thing now is to get started and keep going.
[newbie] MySQL
Is it possible to export a MySQL Database from 1 machine, and import it into another? If so, please explain how its done. Thanks. Ryan Le Gros
[newbie] MySQL and PHP question
I am getting very tired of uploading my scripts to test them so I thought I would try out Linux. I am not sure were to put my scripts though, could somebody tell me were I should store my HTML,PHP files at and just were MySQL is located. I thought it would be in something like mysql/bin for something but do not see it anywhere. I have apache running on my Linux boot, or at least I am pretty sure. Anyway easy enough to get, if somebody could just tell me were to look and were to put the files (HTML,PHP,PERL). Thanks for you help Stephen
RE: [newbie] MySQL and PHP question
I am having sort of the same problem, you can place all of your html, PHP files in the apache-htdocs folder. I believe this is the name of the root folder. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kandace Little Sent: Wednesday, October 18, 2000 6:20 AM To: [EMAIL PROTECTED] Subject: [newbie] MySQL and PHP question I am getting very tired of uploading my scripts to test them so I thought I would try out Linux. I am not sure were to put my scripts though, could somebody tell me were I should store my HTML,PHP files at and just were MySQL is located. I thought it would be in something like mysql/bin for something but do not see it anywhere. I have apache running on my Linux boot, or at least I am pretty sure. Anyway easy enough to get, if somebody could just tell me were to look and were to put the files (HTML,PHP,PERL). Thanks for you help Stephen
[newbie] Mysql for mandrake
Where can I find a newer version of MySql,than whats on the 7.02 CD? I need one that will work under Mandrake 7.02. and preferably 3.22 or higher...and I need it in RPM...not tar.gz -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit=
RE: [newbie] Mysql for mandrake
Try http://www.mysql.com They've got source, and binary there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of KompuKit Sent: Wednesday, October 11, 2000 4:25 PM To: Linux-Mandrake Subject: [newbie] Mysql for mandrake Where can I find a newer version of MySql,than whats on the 7.02 CD? I need one that will work under Mandrake 7.02. and preferably 3.22 or higher...and I need it in RPM...not tar.gz -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit=
Re: [newbie] Mysql for mandrake
Okay, I just got thru installing the Perl 5.6.0 base RPM, and the sister RPM...for the complete pkgfrom off the mandrake 7.1 rpmfind site. I installed DBI 1.13.rpm and a few other pkgs. I'm trying to setup a Mysql web interface admin...it requires DBI and DBD...I use to get DBI errors,when calling the cgi script... now I get DBD...where can I find the approriate RPMS for my system...? Tyler Longren wrote: Try http://www.mysql.com They've got source, and binary there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of KompuKit Sent: Wednesday, October 11, 2000 4:25 PM To: Linux-Mandrake Subject: [newbie] Mysql for mandrake Where can I find a newer version of MySql,than whats on the 7.02 CD? I need one that will work under Mandrake 7.02. and preferably 3.22 or higher...and I need it in RPM...not tar.gz -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit= -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit=
[newbie] mysql-where?
Where is the path, that MYSQL was installed, in the 7.02 mandrake version...have a app that needs to know where the "INCLUDE" path of the mysql install path is? where is it? can't find it -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit=
[newbie] MySQL w/ tcp wrappers?
Does anyone know if Mandrake compiles MySQL to go through tcp wrappers? It doesn't seem to but I don't want to recompile it by hand if someone knows how to switch tcp wrappers on for it w/out such hassle. :) *^*^*^* Was it a dream where you see yourself standing in sort of sungod robes on a pyramid with a thousand naked women screaming and throwing little pickles at you? -- Real Genius
[newbie] mysql-startup
whats the mysql homepage? and where/how do you configure it...get it going? -- Registered Linux User:167369 =KompuKit= Kit Goins ICQ# 7110071 [EMAIL PROTECTED] Lowell, Mass. Web Designerhttp://kitdesigns.bizhosting.com WebServer: http://kompukit.dyndns.org (Server Runs between M - F 6pm-12am, S S 12pm-12am EST) =KompuKit=
Re: [newbie] MySQL RPMS
Hi Michael... So far, I haven't had any luck figuring out what to do with MsSQL...the reason is that I left where the Linux box is...China!! I WAS supposed to install a help desk software that uses both MySQL and PHP for dynamic page updates and other cool features, but I never got that far. One of the "smart guys" there had a problem with understanding that I had a 99.98% hackerproof firewall installed and recommended that the group unplug it from the 'net which defeated the purpose of it's use and functionality. Not to mention 6 weeks of my effort (setting up 2 versions, 8 reloads, a web server, a secure shell server, an FTP and a secure FTP server, an NMS client, and a DHCP server for 2 ranges on 2 network cards, and of course the firewall system with NAT-MASQing for access to the Internet). Not a little issue to me. Anyhow, sorry to drown you in the gory details. There's much more out there to do for more appreciative groups than this one. I will attempt to do a duplicate install on a laptop and see what happens, but I expect results to vary considerably (but this is the only platform that I have access to at the moment). However the MySQL and the PHP information SHOULD be pretty generic, so I will let you know in a few days. Steve Weltman (FINALLY in the US again!!) - Original Message - From: "Michael Hatzakis" [EMAIL PROTECTED] To: "Steve Weltman" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 30, 2000 10:24 AM Subject: Re: [newbie] MySQL RPMS Steve, When you installed MySQL, do you use PHP? I tried and it did not recognize the MySQL specific commands. Did you hve to re-install PHP or do use another program to access Sql database? Thanks, Michael On Mon, 28 Aug 2000, Steve Weltman wrote: Hi Paul, There is a new version (3.23) for Mandrake available from either mySQL or from http://news.freshmeat.net You can get all of the needed components in RPM format for easier installation. I did this in about an hour and I needed to uninstall my current version first. Just my 2 cents! Hope you have a great weekend! Steve Weltman (from Beijing) - Original Message - From: "Paul" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 27, 2000 2:02 AM Subject: [newbie] MySQL RPMS Hi, the MySQL RPMS are on the EXTension disk. MySQL-3.22.32-5mdk.i586.rpm MySQL-bench-3.22.32-5mdk.i586.rpm MySQL-client-3.22.32-5mdk.i586.rpm MySQL-devel-3.22.32-5mdk.i586.rpm MySQL-shared-libs-3.22.32-5mdk.i586.rpm Paul -- Don't sweat the petty things, and don't pet the sweaty things. )0([[EMAIL PROTECTED]])0( http://nlpagan.net - ICQ 147208 Registered Linux User 174403 -=PINE 4.21+Linux Mandrake 7.1=-
Re: [newbie] MySQL RPMS
OOPS!! This was meant to be a private mail...Please disregard the previous. Thx! Steve W. - Original Message - From: "Steve Weltman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 8:19 AM Subject: Re: [newbie] MySQL RPMS Hi Michael... So far, I haven't had any luck figuring out what to do with MsSQL...the reason is that I left where the Linux box is...China!! I WAS supposed to install a help desk software that uses both MySQL and PHP for dynamic page updates and other cool features, but I never got that far. ===snip===
Re: [newbie] MySQL RPMS
Paul, One thing I tried is install it using the RPM manager and PHP did not recognize it. Ie., did not recognize any of the sql commands, ie., mysql_connect(). It did work on it's own, though. So, I took it out and tried manual install and ./config using the instructions. Same. Then I removed PHP and tried to reinstall it with MySQL support using the compile instructions, but it did not find support to MySQL even though I turned on the switch --with-mysql=/dir... (details escape me) but the ./config still crashed looking for the MySQL exececution files. So, still sql'less in seattle. Thanks, Michael On Sat, 26 Aug 2000, Paul wrote: Hi, the MySQL RPMS are on the EXTension disk. MySQL-3.22.32-5mdk.i586.rpm MySQL-bench-3.22.32-5mdk.i586.rpm MySQL-client-3.22.32-5mdk.i586.rpm MySQL-devel-3.22.32-5mdk.i586.rpm MySQL-shared-libs-3.22.32-5mdk.i586.rpm Paul -- Don't sweat the petty things, and don't pet the sweaty things. )0([[EMAIL PROTECTED]])0( http://nlpagan.net - ICQ 147208 Registered Linux User 174403 -=PINE 4.21+Linux Mandrake 7.1=-
Re: [newbie] MySQL RPMS
Steve, When you installed MySQL, do you use PHP? I tried and it did not recognize the MySQL specific commands. Did you hve to re-install PHP or do use another program to access Sql database? Thanks, Michael On Mon, 28 Aug 2000, Steve Weltman wrote: Hi Paul, There is a new version (3.23) for Mandrake available from either mySQL or from http://news.freshmeat.net You can get all of the needed components in RPM format for easier installation. I did this in about an hour and I needed to uninstall my current version first. Just my 2 cents! Hope you have a great weekend! Steve Weltman (from Beijing) - Original Message - From: "Paul" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 27, 2000 2:02 AM Subject: [newbie] MySQL RPMS Hi, the MySQL RPMS are on the EXTension disk. MySQL-3.22.32-5mdk.i586.rpm MySQL-bench-3.22.32-5mdk.i586.rpm MySQL-client-3.22.32-5mdk.i586.rpm MySQL-devel-3.22.32-5mdk.i586.rpm MySQL-shared-libs-3.22.32-5mdk.i586.rpm Paul -- Don't sweat the petty things, and don't pet the sweaty things. )0([[EMAIL PROTECTED]])0( http://nlpagan.net - ICQ 147208 Registered Linux User 174403 -=PINE 4.21+Linux Mandrake 7.1=-
Re: [newbie] MySQL RPMS
On Wed, 30 Aug 2000, Michael Hatzakis wrote: Paul, One thing I tried is install it using the RPM manager and PHP did not recognize it. Ie., did not recognize any of the sql commands, ie., mysql_connect(). It did work on it's own, though. So, I took it out and tried manual install and ./config using the instructions. Same. Then I removed PHP and tried to reinstall it with MySQL support using the compile instructions, but it did not find support to MySQL even though I turned on the switch --with-mysql=/dir... (details escape me) but the ./config still crashed looking for the MySQL exececution files. I hope someone else can step in, this is getting over my head. I don't use MySQL, so I can't help you with these things... GOod luck! Paul -- When you're born again, do you have two bellybuttons? http://nlpagan.net - ICQ 147208 - Registered Linux User 174403 -=PINE 4.21 on Linux Mandrake 7.1=-
Re: [newbie] MySQL RPMS
Hi Paul, There is a new version (3.23) for Mandrake available from either mySQL or from http://news.freshmeat.net You can get all of the needed components in RPM format for easier installation. I did this in about an hour and I needed to uninstall my current version first. Just my 2 cents! Hope you have a great weekend! Steve Weltman (from Beijing) - Original Message - From: "Paul" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 27, 2000 2:02 AM Subject: [newbie] MySQL RPMS Hi, the MySQL RPMS are on the EXTension disk. MySQL-3.22.32-5mdk.i586.rpm MySQL-bench-3.22.32-5mdk.i586.rpm MySQL-client-3.22.32-5mdk.i586.rpm MySQL-devel-3.22.32-5mdk.i586.rpm MySQL-shared-libs-3.22.32-5mdk.i586.rpm Paul -- Don't sweat the petty things, and don't pet the sweaty things. )0([[EMAIL PROTECTED]])0( http://nlpagan.net - ICQ 147208 Registered Linux User 174403 -=PINE 4.21+Linux Mandrake 7.1=-
[newbie] MySQL RPM
Trying to find an RPM for mandrake to install MySQL, can someone suggest where to find it. Just got PHP running nicely on apache. Thanks, Michael
Re: [newbie] MySQL RPM
mysql.com should be installed already though (GPL)
Re: [newbie] mySQL installation
yes, whaddya wanna know? -- From: Marc Herms (Mercator GmbH) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [newbie] mySQL installation Date: 15 February 2000 16:55 WHO could help me with mySQL installation? marc * * MERCATOR GmbH * * Your Presence Provider * *http://mercator.net * * e-mail: [EMAIL PROTECTED] * *
[newbie] mySQL installation
WHO could help me with mySQL installation? marc * * MERCATOR GmbH * * Your Presence Provider * *http://mercator.net * * e-mail: [EMAIL PROTECTED] * *
[newbie] mysql socket
Hi, I'm trying to install MySQL on my Mandrake 5.3 machine. I'm installing from source. When I try running mysqladmin, I get an error saying that /tmp/mysql.sock doesn't exist. It doesn't. What is this file, and how do I create it? Thanks, Hidong
