Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#715 closed Question/How do I...? (fixed)

How do i create a MySql database?

Reported by: Ken Montenegro Owned by: Jamie McClelland
Priority: High Component: Tech
Keywords: mysql mandela.mayfirst.org Cc:
Sensitive: no

Description

Can you provide the link/instructions for the creation of mysql databases? I looked on the wiki and can't seem to find discrete directions.

If the "old" method prevails, then one db for masamikawai.net and another for lomasdelegation.net would be super.

Thanks for all the amazing work!

Change History (10)

comment:1 Changed 11 years ago by alfredo

Keywords: mysql added
Priority: UrgentHigh
Type: Bug/Something is brokenQuestion/How do I...?

Do you handle command line comfortably, Ken?

If so

https://support.mayfirst.org/wiki/create_mysql_database

If not, we'll do it. Just tell us to. It's a three word command that does it; we have a script for it.

Alfredo

changing type to "how do I" and lowering priority to "high"

comment:2 Changed 11 years ago by Ken Montenegro

When running the command from SSH, this is the output: ====== login as: masamikawai masamikawai@…'s password: Linux mandela 2.6.18-6-xen-686 #1 SMP Wed Jan 23 07:51:35 UTC 2008 i686

The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. 0 masamikawai@mandela:~$ mf-mysql-create masamikawai_wp

We trust you have received the usual lecture from the local System Administrator. It usually boils down to these three things:

#1) Respect the privacy of others. #2) Think before you type. #3) With great power comes great responsibility.

Password: Sorry, user masamikawai is not allowed to execute '/usr/local/sbin/mf-mysql-crea te-helper' as mysql-creator on mandela. 1 masamikawai@mandela:~$ Sorry, user masamikawai is not allowed to execute '/usr/local/sbin/mf-mysql-crea te-helper' as mysql-creator on mandela. -bash: Sorry,: command not found 127 masamikawai@mandela:~$ ==== Maybe to close the ticket, can you create a DB for masamikawai.net and one for lomasdelegation.net?

Thanks A & J for all the amazing work you're doing. Have a nice weekend.

,

comment:3 Changed 11 years ago by alfredo

Resolution: fixed
Status: newclosed

Okay Ken. These are set up. The info for them is in a file called newdbinfo in

/home/members/kenmontenegro

Anything you need, here we are.

Alfredo

closing ticket

comment:4 Changed 11 years ago by Daniel Kahn Gillmor

Keywords: mandela.mayfirst.org added
Summary: MySqlHow do i create a MySql database?

comment:5 Changed 11 years ago by Ken Montenegro

Resolution: fixed
Status: closedreopened

The information for lomasdelegation.net didn't work. Please check/reset mysql pwd for the km_lomasdelegation db.

Thanks!

comment:6 Changed 11 years ago by alfredo

I don't see the password file in there anymore, Ken. Maybe you removed it for security reasons or something? I need to check what happened before doing anything else so I need to know what the user/pass was and can't know that in public. Could you put that file back in there if it was removed, please? Thanks a million.

comment:7 Changed 11 years ago by Ken Montenegro

I just checked and it's there. Visible using both Fugu on Mac OS X and using SSH.

connected to masamikawai.net. went to /home/members/kenmontenegro. file is there.

from ssh, hostname results in mandela.

for some odd reason, I can log into malcolm.mayfirst.org as kenmontenegro but not onto mandela.mayfirst.org. . .

thanks.

comment:8 Changed 11 years ago by alfredo

Check that same file now, Ken. I think those configs will work for you. Let us know if there are any other problems.

comment:9 Changed 11 years ago by Ken Montenegro

Resolution: fixed
Status: reopenedclosed

Thanks!

comment:10 Changed 11 years ago by Jamie McClelland

FYI, the problem causing the original error is being discussed in ticket #729.

Please login to add comments to this ticket.

Note: See TracTickets for help on using tickets.