Skip to main content

:: how to reset auto increment in mysql

:: how to reset auto increment in mysql
mysql> ALTER TABLE table_name AUTO_INCREMENT = 0;
0 = starting value for auto increment

:: links
+ googlelinux
+ bayublitar
Labels:

Comments

Post a Comment

Popular posts from this blog

:: install postfix, cyrus, courier, mysql, postfixadmin, squirrelmail on opensuse

:: what is please take a look this. :: install dependency + installing berkeleyDB + installing MySQL + installing Apache + installing PHP :: remove sendmail [ root:~ ]# rpm -e sendmail --nodeps :: build cyrus-sasl [ root: ~ ]# wget ftp://ftp.andrew.cmu.edu/pub/cyrus-mail/cyrus-sasl-2.1.23.tar.gz [ root: ~ ]# tar -xzf cyrus-sasl-2.1.23.tar.gz [ root: ~ ]# groupadd mail [ root: ~ ]# useradd -u 96 -d /usr/cyrus -g mail cyrus [ root: ~ ]# passwd cyrus [ root: ~ ]# cd cyrus-sasl-2.1.23/ [ root: cyrus-sasl-2.1.23 ]# export CPPFLAGS="-I/usr/local/mysql/include/mysql" [ root: cyrus-sasl-2.1.23 ]# ./configure --enable-anon --enable-plain --enable-login --enable-sql --disable-krb4 --disable-otp --disable-cram --disable-digest --with-mysql=/usr/local/mysql --with-plugindir=/usr/lib/sasl2 --without-pam --without-saslauthd --without-pwcheck [ root: cyrus-sasl-2.1.23 ]# make && make install :: installing Postfix + download postfix [ root:~ ]# wget http://mirror.postfix.jp/...
Post a Comment
:: Read more..

Simple Step Installing WordPress in Ubuntu 24.04

Using ols1clk.sh Script This step will: Install OpenLiteSpeed Install PHP Secure your server Install MySQL Set up WordPress Run the script: bash <( curl -k https://raw.githubusercontent.com/litespeedtech/ols1clk/master/ols1clk.sh ) -w  Configuring WordPress Open your browser and navigate to your domain: http://yourdomain.com You’ll be greeted by the famous WordPress installation wizard. Follow these steps: Select your preferred language. Enter your site title, username, and password for the WordPress admin account. Click "Install WordPress." And just like that, you’ve done it!
Post a Comment
:: Read more..

:: wordpress theme reset to default

:: whatis wordpress WordPress is an open source CMS, often used as a blog publishing application powered by PHP and MySQL. It has many features including a plugin architecture and a templating system. -[ http://en.wikipedia.org/wiki/Wordpress ]- :: reset themes wordpress to default # with cli [ linux: ~ ]$ mysql -u user -p mysql> use dbwordpress; mysql> UPDATE wp_options SET option_value = 'default' WHERE option_name = 'template'; mysql> UPDATE wp_options SET option_value = 'default' WHERE option_name = 'stylesheet'; # share hosting / cpanel / phpmyadmin 0. login on cpanel / phpmyadmin 1. select db for wordpress 2. select SQL tabs and run this command: UPDATE wp_options SET option_value = 'default' WHERE option_name = 'template'; UPDATE wp_options SET option_value = 'default' WHERE option_name = 'stylesheet'; 3. click GO 4. open your site, if you still get blank screen, you can login on admin page ...
Post a Comment
:: Read more..