会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 133914个问题
JAVA 全系列/第五阶段:网页编程和设计/Javascript 语言(旧) 21721楼

MySQL的安装问题。

win10系统,64位,安装5.7.36版本。

再下面这幅图的一步卡住啦。(自己百度网上各种方式,还是会这样)。

image.png

log里的内容如下:

Saving my.ini configuration file...

Saved my.ini configuration file.

Ended configuration step: Writing configuration file


Beginning configuration step: Updating Windows Firewall rules


Adding a Windows Firewall rule for MySQL57 on port 3306.

Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow

确定。



Successfully added the Windows Firewall rule.

Ended configuration step: Updating Windows Firewall rules


Beginning configuration step: Adjusting Windows service


Attempting to grant Network Service require filesystem permissions.

Granted permissions.

Adding new service

New service added

Ended configuration step: Adjusting Windows service


Beginning configuration step: Initializing database (may take a long time)


Deleting the data directory from a previous (failed) configuration...

Attempting to run MySQL Server with --initialize-insecure option...

Starting process for MySQL Server 5.7.36...

Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...

2022-05-26T07:06:52.121753Z 0 [ERROR] Invalid value for named_pipe_full_access_group.

2022-05-26T07:06:52.121817Z 0 [ERROR] Aborting

Process for mysqld, with ID 12228, was run successfully and exited with code 1.

Failed to start process for MySQL Server 5.7.36.

Database initialization failed.

Ended configuration step: Initializing database (may take a long time)


JAVA 全系列/第四阶段:数据库与AI协同技术实战/MySQL数据库 21722楼
JAVA 全系列/第四阶段:数据库与AI协同技术实战/SQL 语言 21723楼
JAVA 全系列/第十阶段:权限控制与安全认证/Shiro 21726楼
Python 全系列/第一阶段:AI驱动的Python编程/Python入门(动画版) 21727楼
Python 全系列/第七阶段:网页编程基础/jquery 21729楼
JAVA 全系列/第六阶段:JavaWeb开发/Servlet技术详解(旧) 21731楼

package com.bjsxt.test;

import com.bjsxt.pojo.Users;
import com.bjsxt.service.UsersService;
import com.bjsxt.service.impl.UsersServiceImpl;

import java.util.List;

public class SelectUsersAllTest {
    public static void main(String[] args) {
        UsersService usersService = new UsersServiceImpl();
        List<Users> list = usersService.findUsersAll();
        list.forEach(e -> System.out.println(e));
    }
}
package com.bjsxt.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class MybatisUtils {
    private static ThreadLocal<SqlSession> threadLocal = new ThreadLocal<>();
    private static SqlSessionFactory sqlSessionFactory = null;
    static {
        //创建SqlSessionFactory
        InputStream is = null;
        try{
            is = Resources.getResourceAsStream("mybatis-cfg.xml");
        }catch (IOException e){
            e.printStackTrace();
        }
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
    }
    //获取SqlSession
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = threadLocal.get();
        if(sqlSession==null){
            sqlSession = sqlSessionFactory.openSession();
            threadLocal.set(sqlSession);
        }
        return sqlSession;
    }

    //关闭SqlSession对象
    public static void closeSqlSession(){
        SqlSession sqlSession = threadLocal.get();
        if(sqlSession!=null){
            sqlSession.close();
            threadLocal.set(null);
        }
    }
}

image.png

报初始化失败

JAVA 全系列/第六阶段:项目管理与SSM框架/Mybatis 21732楼
JAVA 全系列/第六阶段:JavaWeb开发/Servlet技术详解 21734楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637