Sun Cobalt Forums by Zeffie.com

stokie21 · Joined: 23 Apr 2009 Posts: 16

ok i have zeffie's version of mysql 4.0.2.1 and i want to install php so i can add a forum to my site. how do i tell what version of php i have, and how to i enter a data base in mysql?

thanks

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

Log into your root of your server:

Log into the super user account:
su root

Log into the mysql server:
mysql --user=root --pass=rootpassword mysql

Enter the following:
shell> mysql --user=root mysql
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.*
-> TO 'mysqlusername'@'localhost'
-> IDENTIFIED BY 'passcode';

Flush the privies:
mysql> FLUSH PRIVILEGES;

stokie21 · Joined: 23 Apr 2009 Posts: 16

[quote="JAISP Tech"]Log into your root of your server:

Log into the super user account:
su root

Log into the mysql server:
mysql --user=root --pass=rootpassword mysql

Enter the following:
shell> mysql --user=root mysql
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON databasename.*
-> TO 'mysqlusername'@'localhost'
-> IDENTIFIED BY 'passcode';

Flush the privies:
mysql> FLUSH PRIVILEGES;[/quote]

Thanks for being the only person to offer help on this site !! I really am very new to this sort of thing can you make your instructions a little more simple, i have never logged into the root account before so kind of dont know how to do this

thanks

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

Telent into your server using a dos prompt.

Type in:

telent xxx.xxx.xxx.xxx

The x's represent the ip address of the server.

You will then need to enter the server user name and pass code

Example:

admin

********

It will ask you for each of these.

stokie21 · Joined: 23 Apr 2009 Posts: 16

i get an error message

it says telent is not a recognized as an internal or external command operable program or batch file

i opened a command prompt and pur in telent 192.168.2.30 which is my server address

i have installed zeffies OpenSSH patch if it helps, also downloaded putty and tried to get in that way, i opened putty put in the server address, then it asked for a user name, i entered su root and it askes for a password, i tried all mine and it will not let me in, is there a defult pass for this? also logged in as admin with my pass and that worked, i put in your text as it is below and it just comes up an error. This server has been restored back to standard with nothing on it apart from the updates

Thanks

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

You would log in:

user: admin
pass: yourpasscode

Then once logged in you type in: su root

You will once again be prompted to enter your admin password again to become the "Root Super User".

Then once your logged in as the "Super User" you can then log into the MySQL database using my instructions above.

Also I did read your comment about being the only person to help you. I thank you for that but wonder why the people whom have this site had never even tried to help you at all. I have not frequented this board for quite some time for lack of interest by the people who run the place and the severe restrictions they have placed on the board and such with little intent on keeping it going.

I don't know why they just do not close this site and be done with it.

stokie21 · Joined: 23 Apr 2009 Posts: 16

it is a little strange, i can not even put a picture up showing the errors i have, i host it on image shack and it says there is a bad word found does my head in !!

well i have another error its saying

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

i am using putty is that ok??

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

Putty works for me logging in to SSH.

Perhaps the MySQL server is not running. To start it manually place this in the command line.

/etc/init.d/mysqld start

Yeah they pretty much block everything in here as this became a spammers dream as 90% of the post's are spammers. I had mentioned to the place a while back that perhaps they should upgrade their FREE message board to a newer one that would curve most of it but I guess they just are not interested in keeping this one going or they don't have the platform that has the resources and stuff to actually run a newer version. Either way this site has become some what useless for helping efficiently.

stokie21 · Joined: 23 Apr 2009 Posts: 16

lol i really am having bad look with this!!

login as: admin
admin@192.168.2.30's password:
Last login: Mon Jan 25 17:27:16 2010 from 192.168.2.3
[admin admin]$ su root
Password:
[root admin]# /etc/init.d/mysqld start
bash: /etc/init.d/mysqld: No such file or directory
[root admin]#

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

Is MySQL installed on the server?

stokie21 · Joined: 23 Apr 2009 Posts: 16

I am sure it was installed, as i said in the above i am very new to this!!. As your the only one who is helping and all i have is a box that i dont know how to use which is useless, would it be better if i give you access to the server to see for yourself?

Thanks

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

go to j a i s p . c o m and send me a message through that site please.

stokie21 · Joined: 23 Apr 2009 Posts: 16

done, and joined your forum

Thanks

Zeffie · Posted: Wed Jan 27, 2010 12:02 am Post subject:

[quote="JAISP Tech"]Putty works for me logging in to SSH.

Perhaps the MySQL server is not running. To start it manually place this in the command line.

/etc/init.d/mysqld start

Yeah they pretty much block everything in here as this became a spammers dream as 90% of the post's are spammers. I had mentioned to the place a while back that perhaps they should upgrade their FREE message board to a newer one that would curve most of it but I guess they just are not interested in keeping this one going or they don't have the platform that has the resources and stuff to actually run a newer version. Either way this site has become some what useless for helping efficiently.[/quote]

I really don't have time to put up with shit like this.

Go sell your other os's elsewhere
_________________
http://www.zeffie.com/
Now I build it and You surf it!
Cobalt Support Specialist since 1999
Cobalt RaQ Repairs, Development, and Maintenance.
Cobalt Spam Filter, Security, Firewall, Anti Virus Products...

JAISP Tech · Joined: 03 Oct 2007 Posts: 103

Actually Zeffie I was able to log into his box and get him started. I use many other OS's and learn many new things.

If you do not wish to help YOUR users and customers that is your choice.

If you want a community that provides help then run the dam thing as I will no longer ever come back here and help anyone to make YOU look good.

Now you can look bad all on your own and just for your smart ass comment I will now give him the ability to take a $50 flea market machine a 100 times more powerful server then any Cobalt you ever worked on, FOR FREE.

You can delete my post but you can never run a community like this as you don't have the time.

Good by Zeffie.