MYSQL and LINUX...

[Dolamite]

I have been learning linux in my spare time... or at least attempting to.

I run Mandrake 9 at the moment, and have been reading numerous tutorials on MySQL and linux.

for some reason though, no matter how many different ways i try it, i cannot get mysql to run unless i use the following command in the terminal

mysqld --user=root --skip-grant-tables

...

i was wondering if someone could perhaps just give me a list of the commands in the order they need to be done in to build a board from scratch.

example:

1. mysqladmin -uroot create database
2. whatever else i might need to do (ive read many things)

so if someone would be willing to do some kind of list like that for me... I would be very grateful.

[Floris]

Originally posted by Dolamite
I have been learning linux in my spare time... or at least attempting to.

I run Mandrake 9 at the moment, and have been reading numerous tutorials on MySQL and linux.

for some reason though, no matter how many different ways i try it, i cannot get mysql to run unless i use the following command in the terminal

mysqld --user=root --skip-grant-tables

...

i was wondering if someone could perhaps just give me a list of the commands in the order they need to be done in to build a board from scratch.

example:

1. mysqladmin -uroot create database
2. whatever else i might need to do (ive read many things)

so if someone would be willing to do some kind of list like that for me... I would be very grateful.

You could try to run the daemon and then login with phpmyadmin and manage it from there. phpmyadmin is pretty easy to setup new users and databases. You just need one for vbulletin and then it is a matter of running the vbulletin install.php file.

Doesn't mysql.org give examples for installation?

[eva2000]

Originally posted by Dolamite
I have been learning linux in my spare time... or at least attempting to.

I run Mandrake 9 at the moment, and have been reading numerous tutorials on MySQL and linux.

for some reason though, no matter how many different ways i try it, i cannot get mysql to run unless i use the following command in the terminal

mysqld --user=root --skip-grant-tables

...

i was wondering if someone could perhaps just give me a list of the commands in the order they need to be done in to build a board from scratch.

example:

1. mysqladmin -uroot create database
2. whatever else i might need to do (ive read many things)

so if someone would be willing to do some kind of list like that for me... I would be very grateful. http://mysql.com/doc/T/u/Tutorial.html ;)

[Dolamite]

Originally posted by xiphoid
You could try to run the daemon and then login with phpmyadmin and manage it from there. phpmyadmin is pretty easy to setup new users and databases. You just need one for vbulletin and then it is a matter of running the vbulletin install.php file.

Doesn't mysql.org give examples for installation?

yeah they do, but on linux (i'm native to windows) i get very confused. I am also setting up some other websites for customers on a server, so i chose linux.

i just kept getting errors, and the only way to get vb working was by running the skip-grant-tables command.... which i assume is not the proper way to set up a board.

[eva2000]

Originally posted by Dolamite
yeah they do, but on linux (i'm native to windows) i get very confused. I am also setting up some other websites for customers on a server, so i chose linux.

i just kept getting errors, and the only way to get vb working was by running the skip-grant-tables command.... which i assume is not the proper way to set up a board. most likely you need to set your mysql root password and mysql usernames' passwords correctly

[Dolamite]

ok, cool... i appreciate the suggestions.... i will read thru this tutorial..


first step in the tutorial....

[root@localhost root]# mysql -h localhost root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
[root@localhost root]#

[Dolamite]

seriously where is the tutorial for idiots like me, who have used windows their whole life and are expected to know all this linux command line stuff.... :rolleyes:

[Pingu]

Ummm, did you (re-)set the root password after installation?

http://www.mysql.com/doc/en/Resetting_permissions.html

[Steve Machol]

Originally posted by Dolamite
seriously where is the tutorial for idiots like me, who have used windows their whole life and are expected to know all this linux command line stuff.... :rolleyes: The command lines are the same. There is no 'Linux command line stuff.'

[Dolamite]

interesting... cuz i never ran any command lines in windows..... yet i never had problems getting mysql running.....

i'll have a look at that pingu... thanks ;)

[Steve Machol]

Originally posted by Dolamite
interesting... cuz i never ran any command lines in windows..... yet i never had problems getting mysql running..... Start -> Run -> cmd

[Dolamite]

Originally posted by Steve Machol
Start -> Run -> cmd

yes i know how to run the dos box (command prompt) i was just saying i never had to do it for setting up mysql.....i just used the mysqladmin program (window)

[Steve Machol]

Well I was just pointing out that this is not 'Linux command line stuff' and there's no reason you can't run these commands in Windows. :)

[Dolamite]

ahh... hehe sorry... i thought you were just trying to be an a$$hole :)

my apologies....

thats good to know, actually.

...

ok... sorry to keep bugging you people... but i have one more issue....

i get Fatal error: Call to undefined function: mysql_connect() in /var/www/admin/db_mysql.php on line 34

now i know i did all the steps to set the password, and i followed the tutorials....

its the whole grant tables thing which totally confuses me.... i've seen this error before, and using --skip-grant-tables i believe fixes it....

but i am running a server on red hat 8, and i wanted to setup mysql service to run on boot, since i am not going to have a spare monitor for the server i am trying to auto-mate everything on boot.

thanks for the help.... and btw vb3 is looking cool so far, can't wait to take it for a test drive ;)

[Steve Machol]

Originally posted by Dolamite
i get Fatal error: Call to undefined function: mysql_connect() in /var/www/admin/db_mysql.php on line 34 This means PHP was not compiled with MySQL support. You'll need to recompile it with this support.

Also there are known problems with RH 8.0. Here's one of them:

http://205.214.66.219/forum/showthread.php?s=&postid=373704#post373704

[Dolamite]

hmm yeah i was wondering.... as i just tryed it with the --skip-grant-tables and got the same error

just out of curiousity..... who do you think will be attending to this bug? is apache or php the culprit...

[Dolamite]

ok... well just fyi...... i edited the files.... i double checked them just now too... for typos...... i get the same error as before even with the edited install file..... i even cleared my browser cache.....