from:"DeNewbie"

Basic Install?

2002-10-06 Thread DeNewbie



After giving up MySQL installation with the RPMs I am now wanting to freshly install 
MySQL 3.23 (the latest) on my SUSE 7.3 Linux machine. I am a sort of newbie to Linux 
also. On p.98 of the Widenius MySQL reference manual I am suppose to do this;

Add the full path;

/usr/local/mysql/mysql/bin

Now I have to add this full pathname of this directory to my PATH environment variable 
so that my shell finds the MySQL programs properly.

How do I do edit this PATH ?

 mike@cords-orj86jfje:/usr/local/mysql/mysql/bin echo $PATH
/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/lib/java/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:/opt/kde2/bin:.:/opt/gnome/bin
mike@cords-orj86jfje:/usr/local/mysql/mysql/bin

Thanks, DeNewbie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Please Help!

2002-10-01 Thread DeNewbie



I am a newbie and I am having a chronic problem getting mysql started up and running. 
I got so frustrated that I uninstalled the mysql rpms and started over again but its 
hasn't helped my situation. My whole problem revolves around mysql_install_db setup. 
This is what I am doing and its simply giving me problems. All I want to do is enter 
the root and host paswords but I can't get past the root password setup.

 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root  password 'new-password'

I input this;

cords-orj86jfje:/usr/bin # mysqladmin -u root  password sqlpass
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 
(2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

How do I correct this situation. Why am I having such a hard time entering these 
passwords. I can't even enter the root password. I'm nearly giving up.  

Thanks, DeNewbie

P.S. I am using SuSe Linux 7.3 and I am using the latest MySQL binary rpm downloads 
ver 3.23 .








-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Testing New Install

2002-09-30 Thread DeNewbie



I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running 
mysql_install_db and afterwards running the commands;

/usr/bin/mysqladmin -u root  password 'new-password'

mysqladmin -u pazin1 sqlpass

and;

/usr/bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'

mysqladmin -u pazin1 -h hostpass

After inputting these passwords as I was told by mysql_install_db was this absolutely 
necessary or did I make my life more difficult as a newbie. Anyway after doing that I 
followed more instructions from p.115 of my MySQL Reference manual written by 
Mr.Widenius. From your advice I was able to get some results for the mysqlshow 
command; I don't know where the test database came from I did not see it from the 
result in my Reference Manual;

cords-orj86jfje:/usr/bin # mysqlshow -u pazin1
+---+
| Databases |
+---+
| mysql |
| test  |
+---+
cords-orj86jfje:/usr/bin # mysqlshow -u sqlpass
+---+
| Databases |
+---+
| mysql |
| test  |
+---+
cords-orj86jfje:/usr/bin # mysqlshow -u hostpass
+---+
| Databases |
+---+
| mysql |
| test  |
+---+

then when I enter what one person told me to enter I get this;


cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass
Enter password:
mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES)
cords-orj86jfje:/usr/bin #

(regardless of what password I entered I was continously kicked out)



I would also like use the mysqladmin version command to see what pops up but I simply 
get no results no matter what I type in;

cords-orj86jfje:/usr/bin # mysqladmin version
cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass
cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1
cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass
cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass



I would also like to know how to shut down the mysql server,how do i do this, it does 
not seem to want to shut down;

cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown
cords-orj86jfje:/usr/bin # safe_mysqld 
[1] 1404
cords-orj86jfje:/usr/bin # A mysqld process already exists




Thanks, DeNewbie

P.S. I am using SuSe Linux 7.3 and I am using the latest MySQL binary rpm downloads 
ver 3.23 .





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Basic RPM installation?

2002-09-28 Thread DeNewbie



In my first posting I had the following problem;


 mike@cords-orj86jfje:/usr/bin safe_mysqld 
 [1] 1759
 mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission 
denied
 rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied
 Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid
 /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
 Please remove it manually and start /usr/bin/safe_mysqld again
 mysqld daemon not started




I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I 
performed the mysql_install_db script all over again, now I have this problem in that 
I get the same response even after removing the cords-orj86jfje.err file.





mike@cords-orj86jfje:/usr/bin safe_mysqld 
[1] 1059
mike@cords-orj86jfje:/usr/bin Starting mysqld daemon with databases from 
/var/lib/mysql
/usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
/usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied
020928 10:47:57  mysqld ended
tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied


[1]+  Exit 1  safe_mysqld
mike@cords-orj86jfje:/usr/bin cd /var/lib/mysql
mike@cords-orj86jfje:/var/lib/mysql ls
mysql  test
mike@cords-orj86jfje:/var/lib/mysql ls -l
total 1
drwx--x--x2 mysqlroot  506 Sep  2 14:20 mysql
drwxr-xr-x2 mysqlroot   35 Sep  2 14:20 test



I have the safe_mysql in my /usr/bin but I get this;




mike@cords-orj86jfje:~ cd /usr/bin
mike@cords-orj86jfje:/usr/bin safe_mysql 
[1] 1118
bash: safe_mysql: command not found
[1]+  Exit 127safe_mysql
mike@cords-orj86jfje:/usr/bin ls safe*
safe-rm  safe_mysqld
mike@cords-orj86jfje:/usr/bin su
Password:
cords-orj86jfje:/usr/bin # safe_mysql 
[1] 1126
bash: safe_mysql: command not found
[1]+  Exit 127safe_mysql
cords-orj86jfje:/usr/bin #




What do I do from here ???

Thanks, DeNewbie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Is MySQL server running OK?

2002-09-28 Thread DeNewbie



I am a newbie and I have just recently installed MySQL. I am somewhat confused as to 
why the tests that I am running from my command prompt are not showing any results yet 
I believe that my MySQL server is running;


mike@cords-orj86jfje:~ cd /usr/bin
mike@cords-orj86jfje:/usr/bin su -
Password:
cords-orj86jfje:~ # safe_mysqld 
[1] 1033
cords-orj86jfje:~ # Starting mysqld daemon with databases from /var/lib/mysql
mysqladmin version
cords-orj86jfje:~ # mysqlshow
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
cords-orj86jfje:~ # mysqladmin version
cords-orj86jfje:~ # mysqlshow
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
cords-orj86jfje:~ # mysqlshow mysql
mysqlshow: Access denied for user: 'root@localhost' (Using password: NO)
cords-orj86jfje:~ #

What is exactly going on?

Thanks, DeNewbie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Basic RPM Installation

2002-09-27 Thread DeNewbie



I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use 
PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to 
install these RPM files.

 MySQL-3.23.52-1.i386.rpm
 MySQL-client-3.23.52-1.i386.rpm
 MySQL-devel-3.23.52-1.i386.rpm

They all installed successfully;

Then from  /usr/local I ran mysql_install_db and I got this;



cords-orj86jfje:/usr/local # mysql_install_db
Installing all prepared tables
020927 18:06:15  /usr/sbin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root  password 'new-password'
/usr/bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd / ; /usr/bin/safe_mysqld 

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com




Now at this point what do I do ??

I put in my passwords successfully but when I entered the 
safe_mysqld  I got this;




mike@cords-orj86jfje:/usr/bin safe_mysqld 
[1] 1759
mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission 
denied
rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied
Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid
/usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
Please remove it manually and start /usr/bin/safe_mysqld again
mysqld daemon not started



What do I do from here ???

Thanks, DeNewbie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Basic RPM Installation

2002-09-27 Thread DeNewbie

--  Forwarded message --
Date: Fri, 27 Sep 2002 19:27:22 -0400
From: DeNewbie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Basic RPM Installation

 I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to 
use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to 
install these RPM files.

  MySQL-3.23.52-1.i386.rpm
  MySQL-client-3.23.52-1.i386.rpm
  MySQL-devel-3.23.52-1.i386.rpm

 They all installed successfully;

 Then from  /usr/local I ran mysql_install_db and I got this;

 cords-orj86jfje:/usr/local # mysql_install_db
 Installing all prepared tables
 020927 18:06:15  /usr/sbin/mysqld: Shutdown Complete

 To start mysqld at boot time you have to copy support-files/mysql.server
 to the right place for your system

 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
 This is done with:
 /usr/bin/mysqladmin -u root  password 'new-password'
 /usr/bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
 See the manual for more instructions.

 NOTE:  If you are upgrading from a MySQL = 3.22.10 you should run
 the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
 able to use the new GRANT command!

 You can start the MySQL daemon with:
 cd / ; /usr/bin/safe_mysqld 

 You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
 cd sql-bench ; run-all-tests

 Please report any problems with the /usr/bin/mysqlbug script!

 The latest information about MySQL is available on the web at
 http://www.mysql.com
 Support MySQL by buying support/licenses at https://order.mysql.com

 Now at this point what do I do ??

 I put in my passwords successfully but when I entered the 
 safe_mysqld  I got this;

 mike@cords-orj86jfje:/usr/bin safe_mysqld 
 [1] 1759
 mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission 
denied
 rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied
 Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid
 /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
 Please remove it manually and start /usr/bin/safe_mysqld again
 mysqld daemon not started

 What do I do from here ???

 Thanks, DeNewbie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Basic Install?

Please Help!

Testing New Install

Basic RPM installation?

Is MySQL server running OK?

Basic RPM Installation

Basic RPM Installation

7 matches

Site Navigation

Mail list logo

Footer information