Welcome To Snipplr
Everyone's Recent Bash Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
With this script a new user gets created and gets his own VirtualHost and database. The username is used for building the domain, so the username "test" leads to the domain test.local.
The password for the MySQL account used for creating the datab...
1
802
posted 10 years ago by derbenni
Credit goes to [shyul](http://forum.mamp.info/memberlist.php?mode=viewprofile&u=61837"shyul") and the original forum post here: [original_post](http://forum.mamp.info/viewtopic.php?t=14115"original_post")
You need to modify the following file " ...\...
0
1052
posted 11 years ago by manolis
**Usage**
> newuser.bash [username]
**What it does**
- Generates a random password with `makepasswd`
- Encrypts it with `mkpasswd` for use with useradd
- Adds the user
- Adds a MySQL Database for user
- Adds a MySQL User for user
-...
1
848
posted 12 years ago by jiewmeng
This shell script helps to refresh a propel schema from an existing database using (the "old") Symfony 1.2 and avoiding the "CURRENT_TIMESTAMP" (MySQL) bug.
0
322
posted 13 years ago by PixEye
Script to backup all MySQL databases and delete copies after X days
1
534
posted 13 years ago by eusonlito
Dumps the contents of a mysql database to a .sql file named by the current date.
0
534
posted 13 years ago by gdvickery
To convert files, especially prior to mysql insert. use file filename to find out encoding
1
670
posted 14 years ago by bionic
Where:
* 3307 is the local port used to connect to the remote database. You can use 3306, however, this could conflict with your PC’s MySQL installation.
* localhost and 3306 is the MySQL address from the remote server (most people will...
0
580
posted 14 years ago by danshields
Handy when web hosts limit database upload size. Create folder in home directory call "mysql_dump", upload and extract mysql file into this directory. Ask web host to enable SSH.
0
742
posted 14 years ago by hotdiggity