gautada

Differences between revisions 25 and 26
⇤ ← Revision 25 as of 2007-10-09 03:21:08 →
Size: 1676
Editor: adsl-159-217-64
Comment:
← Revision 26 as of 2007-10-09 03:28:28 → ⇥
Size: 1987
Editor: adsl-159-217-64
Comment:
Deletions are marked like this. Additions are marked like this.
Line 35: Line 35:
Notes for forum posts or bug reports that get reused time and time again. Notes from projects, forum posts, or bug reports that get reused over time.
Line 44: Line 44:

=== MySQL ===

==== Create Database ====

{{{
%>mysqladmin --user=root --password create [database_name]
}}}

==== Create User ====
{{{
%>mysql --user=root --password mysql
mysql>GRANT ALL PRIVILEGES ON [database_name].* TO 'monty'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
}}}

Introduction

"An investment in knowledge always pays the best interest." -- Benjamin Franklin

Greetings and Salutations,

I deliver solutions to clients based on open-source technology. My professional interests center around the political, financial, and technical issues involved in the adoption of open-source into business. Other than that, all I am interested in is trying to make my wife smile.

[http://www.gautier.org/identity Adam T. Gautier (aka "Adam Gautier", "gautada")]

Community Activity

Networking

Projects

Specs and information on projects that I am interested in.

Notes

Notes from projects, forum posts, or bug reports that get reused over time.

Package Delete and Reinstall

%>sudo apt-get check <package name>
%>sudo apt-get remove --purge <package name>
%>sudo apt-get install <package name>

MySQL

Create Database

%>mysqladmin --user=root --password create [database_name]

Create User

%>mysql --user=root --password mysql
mysql>GRANT ALL PRIVILEGES ON [database_name].* TO 'monty'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;

gautada (last edited 2008-08-06 17:00:35 by localhost)