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
2001
posted 12 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
2304
posted 14 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
1988
posted 14 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
952
posted 15 years ago by PixEye
Script to backup all MySQL databases and delete copies after X days
1
1717
posted 15 years ago by eusonlito
Dumps the contents of a mysql database to a .sql file named by the current date.
0
1665
posted 15 years ago by gdvickery
To convert files, especially prior to mysql insert. use file filename to find out encoding
1
1899
posted 16 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
1618
posted 16 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
1992
posted 16 years ago by hotdiggity