红联Linux门户
Linux帮助

linux下关于insert的问题,菜鸟求答

发布时间:2009-09-06 21:47:12来源:红联作者:stmemory
linux下装了sql10G,每次要丢弃数据库和添加记录到表单都要执行
mysql -u root -p
输入密码
sql>insert into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) value ('%', 'biao1',PASSWORD('xxxxxx'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',,'Y','','','','',0,0,0,0);
sql>create database biaoge;
sql>exit

能不能跳过输入用户名和密码,直接把用户名和密码写进INSERT语句里面,我的想法是做个sh后缀的脚本文件直接自动执行一句语句,从而达到上面所能执行的结果.(结果是建立一个叫biaoge的表单,并且添加一行固定记录到biao1的表单里面)
菜鸟求助,谢谢各位大侠
文章评论

共有 0 条评论